MSBI (SSIS/SSRS/SSAS) Online Training

Monday, February 23, 2009

SSIS - How to execute Package from CommandPrompt

Hi ,
already I posted how to execute a SSIS package by using command line.
Once again am adding some more points to make easy.
SSIS - HOW TO EXECUTE A PACKAGE THROUGH THE CMD LINE
It a simple to execute the package from cmd window without using MSVS-2005.
Just open the command prompt.
Type dtexec command
And type the package name along with the /file prefix.

Example:
C:\>DTEXEC /file Export.dtsx
So it means Export.dtsx is stored in the C:\ directly.
Just browse your SSIS-Package-folder and add /file and the package name along with .dtsx extension.

See for more details:
http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2008/08/31/dtexec-exe-what-are-you-doing.aspx

No comments: