April 4, 2008 at 7:01 am
I jus wnat to deploy a package from bids or from saved file location into a particular server?
Could you plz explain me how to do this the process ?
thankz
April 4, 2008 at 7:25 am
Open 'SQL Help Books Online' and go to URL
"ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/0f5fc7be-e37e-4ecd-ba99-697c8ae3436f.htm"
This will provide a comprehensive step by step guide to deploy SSIS packages.
You basically have two options you can either build the SSIS package and copy the 'built' file across to the destination server and install/deploy.
The alternative is to file>save as a .dtsx file and manually import the file into 'Integration Services' from file system from where you can run/schedule as required.
Check http://msdn2.microsoft.com/en-us/library/ms140117.aspx for additional info
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply