Home > SSIS Best Practices > SSIS – Scheduling a SSIS Package in a SQL Job

SSIS – Scheduling a SSIS Package in a SQL Job

image

If we need a config file.

image

If we need to embed credential in the connection string in the data source.

image

If we need to use Command Line (It’s an example where a SSIS package creates an Excel file.).

image

Or,

image

"D:\MSSQL2005\MSSQL$HSVR11 (x86)\90\DTS\Binn\DTExec.exe" /DTS "\MSDB\etl_Send_Excel" /SERVER lsvrname /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: