Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Running a SSIS package through dtexec comand promp

Author  Topic 

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-12-10 : 15:28:15

I have a SSIS package (I saved the package as SQL Server type) that exist on the following location on a server.

E:\Projects\Balls\IntegrationProject\BallsIntegrationProject\BallsIntegrationProject\Package.dtsx

On this server I sucessfully able to run this package from SSIS. Now I want to run it using dtexec in DOS prompt.
In the DOS prompt I tried the following syntax but it did not work. What should be my Syntax? Please suggest.

dtexec SQL E:\Projects\Balls\IntegrationProject\BallsIntegrationProject\Ball
sIntegrationProject\Package.dtsx

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-12-10 : 15:50:55
Never mind. I got it right.

dtexec /f E:\Projects\Balls\IntegrationProject\BallsIntegrationProject\BallsIntegrationProject\Package.dtsx

the slash f defined a file package
Go to Top of Page
   

- Advertisement -