SSIS (SQL Server Integration Services) : Execute Package

You can execute package directly using dtexec.exe or through T-SQL/Stored Procedure.

Direct Execution
dtexec /F "C:\SSISSamples\Startup.dtsx"

Through T-SQL/Stored Procedure
1. Allow  your SQL Server to execute “xp_cmdshell
2. xp_cmdshell ‘dtexec /F "C:\SSISSamples\Startup.dtsx" ‘

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s