Friday, March 9, 2012

Deploying IS properly

Hi,

How do i deploy IS package properly? can i just copy the .dtsx and assign that in an sql jobs?

thanks a lot

cherriesh

With DTExecUI you can build command line that can be executed using DTExec in a job see

Here another article about it|||

cherriesh wrote:

Hi,

How do i deploy IS package properly? can i just copy the .dtsx and assign that in an sql jobs?

thanks a lot

cherriesh

A short answer could be yes.

You can deploy SSIS packages to a file system folder or store them in a DB. You could also use the 'deployment utility' that is part of BIDS, but there are some know issues with that (e.g. deploying a config file used by multiple packages).

If you are going to deploy the packages to multiple environments; make sure you use 'package configurations' to set some property' values at run time dynamically. For more info:

http://technet.microsoft.com/en-us/library/ms137900.aspx

No comments:

Post a Comment