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.

This requirement sounds flaky to me.

You want an automatic process, and...

You should try posting this in the DTS forum.

This one is for SSIS.

If you lookup the function, you'll find that 1/true and 0/false are the only two results it provides per check. You tested the value and found it to be false...

kevin.mitchell (5/1/2012)

---

Hi,

I trying to carry out some basic file manipualtion within a Script Task.

I have 2 existing files Header.Txt and Footer.txt and I would like to append them to a...