Try understanding the Execution Tree of any SSIS package while in execution. Please google.

It depends, largely.

Please google WQL

Please follow here

I believe this is a case of file copy/append. What is the issue you are facing. Try using a ST

A good forum...people...we have a forum...but it's just you and me discussing...gather momemtum

Help us to help you better.

Please explain what do you wish to do with EST(Execute SQL Task)

Nice article John.

We also have a thread running on password protecting an Excel file.

Please follow here

Let's demystify!!!

Business Analytics is a part of whole package which is known as Business Intelligence.

Analytics which is deived from the word Analysis facilitates the user to dig deeper into the...

Thanks for replying back 🙂

Just incase if time permits,

Try the following which I found simply awesome!! But try only if time permits and you are ready to bang your head...

Ohh!! you posted a new reply..plz ignore the question raised for string variable 😀

It's always nice to hear back.

Always remember to make your .NET scripts fool proof specially in SSIS as alot depends upon them even if the case is to just add...

Though Microsoft has a provided Web Service Task..I also has made a provision of ST/SC...the only limit is data staging designers imagination!!! 🙂

I know how to do this in DTS and VBScript. I can't figure it out in SSIS. Links, generic directions, actual code... any of the above would...

Rich,

Thanks for the alternate. 🙂

Judy,

HTH

ST=Script Task

You owe me 50 bucks...just kidding;-)