Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What Is Done When You DEPLOY a Package 1

Status
Not open for further replies.

JohnBates

MIS
Feb 27, 2000
1,995
US
hello SSIS experts,

When you deploy a project/package, what exactly happens?
I assume some kind of "executable" object is created. But where/what is created? SSIS 2005

Thanks, John
 
when you build/deploy a SSIS project a manifest file will be created and a copy of all the projects packages will be placed in the directory you specified, this is the /bin by default. The manifest is an executable that will install the SSIS packages when ran on the server.

If you are doing a filesystem install you really don't need to do this. The files placed in the /bin are exactly the same as those in your project folder. Under a file system package deployment you can simply copy your project pacjages to the directory you want to run them from on the server. This can be any directory, but if you want them to be displayed under the SSIS server in SSMS they need to be placed in a directory that is typically 'InstallPath'\90\DTS
you can make sub directories in here that will be displayed in SSMS.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top