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