ramlicious Blogs by Tina & Prabhu

August 6, 2010

Running Integration Packages from Command Prompt

Filed under: SQL Server — Prabhuram @ 8:38 am

It is simple to run a complex SQL task from command prompt. All you have to do is create a Integration Services Project using SQL Service Business Intelligence Development Studio and create a package. Say for example an Import/Export Package.

And then schedule or run the dtexec.exe from the command prompt.

DTEXEC.EXE /F "[path to file]\Import UnProc Act.dtsx" >> "Execute Package.log"

 

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress