Ok, I created SSIS packages on my local box. All of my packages are using config files for the db connections and other configurations that'll be changed per environment. My question is how do I deploy the .dstx file and the associated config file to the servers?
Right now I'm running the packages in BIDS as I create them. I now want to run them on an actual server
One way is to map a drive (or just open a remote folder) to the server, and then copy the files there.I suggest you create a folder on the server to hold the SSIS stuff. From there you can create subfolders if you desire.|||
would I need to create folders for each package or no? How will the SSIS package now what config file is assocaited with it?
|||
IGotyourdotnet wrote:
would I need to create folders for each package or no? How will the SSIS package now what config file is assocaited with it?
You don't need to create a folder for each package, though that decision is up to you.
In the package (control flow, right click, package configurations), you specify which configuration file to use.
No comments:
Post a Comment