khorkh888 (5/15/2012)

---

Hey All Expertises,

I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:

Date KPI...

You didn't mention the 'c' word...

Really? Did not know that - thanks for sharing.

Not that I know of.

But there are a couple of things you can do.

1) Find a decent text viewer that will open big files quickly and allow you to navigate...

vinu512 (5/14/2012)

---

tbabs25 (5/14/2012)

---

Can anyone help me in coverting the output I am geting when a type in my select statement.

I get a number in return instead of data.

select va_title

from contact...

SSIS sorts are heavy on RAM - have you checked the server's health at the point where the sort goes bad?

If you want to be a bit more sophisticated, one thing you could do would be to set up an import-logging table along the lines of:

BatchNo

FileName

RecordsInFile

RecordsImported

RecordsUpdated

Your package would need to...

Shouldn't be hard - post back if you can't make it work.

The column could be stored as a datetime and another computed column added which does the suggested CONVERT on the date to store it in the format you require. Seems...

Looks like 62 points to me 😛

haichells (5/8/2012)

---

bcp may not work because the output of a stored procedure needs to be exported to a flat file. since it is not taken direct from a table nor...

+1

Please provide some sample data, along with expected results, which may make...

Yes, using dataflow tasks.

Sounds like you might have some reading up to do!

haichells (5/7/2012)

---

Can we name the .csv file dynamically. i.e for example file name should be "XXXXX_mmddyyyy.csv" it should be suffixed with current date so that it will not overwrite and...

A simple SSIS package would do this easily, if that is an option.