You can use compression when using either but at least with TDE you won't get much of a compression ratio. If you're encrypting many columns or are using lots of...

Not if you're using a Flat File Destination but you could go back and have a look at the solution-structure brad.mason5 posted earlier to get multiple csv files.

You're welcome. Thanks for the feedback.

Bing "wmi alert" to read about them for SQL Server Agent. Also lookup "ssis wmi event watcher" not because you need to use the object in ssis but because the...

athi_ssn (2/12/2013)

---

I have created a sample package for the first 5 scripts having 5 different sources,dataflow task and destination. I wanted to know if there is any other simple way...

If you have a look at any of the three articles I linked to above you'll see where I talk about this issue and the pros of "watching" for a...

What is there to disagree about? That's not the same as watching a directory and processing a file as soon as it exists.

Depending on the size of the package...

:ermm: That doesn't really get you there. The key operative word in the ask is "watch."

Side note: The % sign in the script above is a shortcut for the Foreach-Object cmdlet.

If this absolutely must be in T-SQL then start Profiler on a test instance, right-click...

I would probably use SSIS for this. A ForEach Loop Container containing a Data Flow that uses the Import Column Transformation is a very powerful combination.

Here is a step-by-step that...

How would a For Loop allow you to watch for a file and process it the moment it arrives?

All statements are atomic, either they complete successfully or they fail, so yes they maintain their own transactions internally to ensure that all work done by the statement either completes...

What you...

Here is a recent thread with more information from some very trusted resources:

http://www.sqlservercentral.com/Forums/Topic1416031-1550-1.aspx