Thanks Folks. The solution works gr8

Thanks all for ur replies.

I used the below transformation :

PROC_DT == "00000000" ? "NULL" : (SUBSTRING(PROC_DT,5,2) + "/" + SUBSTRING(PROC_DT,7,2) + "/" + SUBSTRING(PROC_DT,1,4))

This had no syntax errors , but...

any ideas ppl?

Thanks Venkat. it works !!!!

yes i did tried using DT_DBDATE . still i got the same error.

any ideas please?

Sorry for not posting in the correct Etiquette . it was actually datetime datatype only (it was my typo error)

----------Use the following command to create the test table:

...

crever , thanks for the reply.

can u let me know the transformation where row count is possible (other than script task) , and can u also outline how to do...

Found out how to check for the existense of a file. If i give the filename like : \\172.25.35.181\ftpdata\EmptyFlatFileTest1.txt ,

i was able to check its existense.

but i faced...

Thanks Micheal. The issue got resolved.

I am not sure how you co-relate this issue with security check?

SSIS Masters, pls provide the solutions

Michael,

As u said , i have put "FOR LOOP container" and two "Execute SQL task" inside this "FOR LOOP container" . i still get issues.

In the "FOR LOOP container", i...

Michael,

can u elaborate more on this.