Extract multiple files

To extract multiple flat files, "For Loop Container" can do the trick:





Public Sub Main()

Dim theLetter, connString As String

connString = Dts.Connections("SourceConnectionFlatFile").ConnectionString.ToString

theLetter = Chr(Dts.Variables("varLetter").Value)

Dts.Connections("SourceConnectionFlatFile").ConnectionString
= Left(connString, 34) & theLetter & ".txt"

Dts.TaskResult = ScriptResults.Success

End Sub


However, Stan Kulp's blog seems to do the same thing. I will try it out. Here is the link: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/75656/

Extract multiple files with a MultiFlatFileConnection data flow task

I have tried his method, and it worked great. Thanks!

Removing TDE by Steve Perry

http://www.sqlservercentral.com/articles/Security/76141/
This article has outlined some of the basic functions of Transparent Data Encryption, it has also given a number of scenarios where even though TDE has been switched off, aspects of that database remain encrypted and explained the potential consequences of this. Finally, this article has documented the proper steps that should be taken in order to ensure the all encrypted data has been decrypted or removed after TDE has been switched off.