Thursday 19 March 2015

Run SSIS Package from command line

The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages. The dtexec utility provides access to all the package configuration and execution features, such as connections, properties, variables, logging, and progress indicators. 
Here I am creating one package and calling that package in command line.
I am creating a File task package.


Make source and destination connection.
Build the package.

Now open the command prompt.


Come to package directory.

Navigate the package existing directory.


Now write the command to execute the package.

Press enter


A: start time
B: Progress
C: source (control type)
D: status
E: Package execution time
F: Package execution finished time
G: Elapsed Time (Time taken to complete the package execution)

Now see the output
Before package execution

After package execution. 

Files are copied on the destination folder.


Hope this is will be helpful for you.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts