Thursday, March 3, 2016

Step by step Procedure to Create a directory on Local System (use of File System Task) -SSIS part 2

How to create a directory on Local System?(use of File System Task)

Go to control flow section
---> Place a file system task and double click on it to configure properties .
 In General tab
you will see Destination directory options

Use directory if exists :True

True means if directory already exists with the same name task will use same  directory without fail.
False means if  directory already exists with the same name task will be failed .

-->Set name and description of the task.

In Operation Tab select

Operation : Create Directory 

 Source Connection: 

Issourcepathvariable  : false 

false means we are not using variables in the source connection.

True means we are using the variables to represent  source connection.

Source connection : <new connection >

usage type : create folder
folder : Path

and press ok

Now connection has been created in the connection managers section.

No comments:

Post a Comment