Hi,

Please check the attachment. I have defined a variable `TimeStamp` and used the script task to assign a value at runtime. you can check if you are...

you can use `Execute SQL Task` on control Flow Task and then use data flow task for further process.

hope this helps 😉

thanks

Nilesh

Hi,

did you lock the variable for writing?

Let me know the variablename you are using for writing.

it should be the same case variable.

try using plus sign (+) instead of ampersand while...

Hi,

When I create the Excel table using DTS package for the same SQL Query it works but when I use SSIS to create excel table it fails.

so I used the...

Sarang,

I have one query which has few columns which are more than 2000 in length. I don't have any constraint on excel sheet. So there is no foriegn key on...