Topics : (Bulk Insert Task, Execute Package Task, Script task, File System Task, FTP Task).
Bulk Insert Task : Used to import text files data to a SQL server.
Advantages : Faster than Data Flow Task,Can get range of rows.
Disadvantages : Source must be a Flat file or a Text file
- Destination must be a SQL Server Table no other destination.
- Cannot Validate , clean or transform the data within this task.
- Cannot get error rows separately.
The below setting is important part in the Bulk Insert Task.
·
Batch size is nothing but how many rows you want to copy at a time?
·
Last row is the row at which you want to end the copy process.
·
First row is the row with which you want the copy process to be
started to a SQL Server. Generally the text files have first few rows with
header or with few lines explaining the document, in such case this is useful.
Execute Process Task : It is used to run third party executables (Winzip, winrar)
for ex:
Executable is : path of the program to be called.
Argument and working directory is shown below.
Ex 2:
Script Task : It is used to write a Visual Studio Script or C# code Script.
After clicking on Edit script , you can and add the code as below and Build. It will save the script.
Precedence constraint : We can use Expression and Logical operation as well.
File System Task :
Creating a folder Microsoft in the source.
FTP Task : To Download/Upload from a FTP folder.
Remote Path is nothing but the FTP Path.
If you put *.* in the FTP Remote Path that means to download all the Files.(.txt, .doc can also be used to download files of a particular type).
Local path is nothing but the place where you want to save the folder.