Load raw text files to sql tables through SSIS

Question

There are bunch of files coming in through zipx with password , and we need to unzip the files and load to different target tables. Also i want to log all information in text files during SSIS execution like

Unzip time of particular file and all files.
Name of Particular file and all files.
record count of particular files including all files.

Pls help how i can setup SSIS to do above task.

Answer 1

Hi @ASHISH SINGH ,

Using Execute Process Task we could unzip the files.

To record the name of particular file and unzip time of particular file and all files, we may use Foreach Loop Container and Execute SQL Task to realize the need.

Here is a detail tutorial for your reference watch.

To record count of particular files including all files, we may use the Script Task with VB code.

Dim counter As _  
System.Collections.ObjectModel.ReadOnlyCollection(Of String)  
counter = My.Computer.FileSystem.GetFiles("C:\TestDir")  
MsgBox("number of files is " & CStr(counter.Count))  

Hope it could give some idea.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October