SSIS deployment Question
Hii I have like 8 packages in my local system.now i have to deploy them to network share. I am confused about config files..what is the relation between config and deploymnt?? Config is necessary for deployment?? Can Any one Tell me How to deploy packages with config files??
October 3rd, 2011 10:37am

My bad ..I have to deploy them to sql server.. Can anyone help mee??
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 10:55am

You need to decide if you need the config file. You need them if you developed them using a different credentials and or file paths. To deploy you may need to modify the package security. This is how you deploy a package to SQL Server: http://msdn.microsoft.com/en-us/library/ms140117.aspx (that is in general). This is a more exhaustive post on how to: http://www.dotnetfunda.com/articles/article1217-sql-server-integration-services-ssis-part-7-options-to-deploy-a-packa-.aspx You can deploy with BIDS Helper easily: http://bidshelper.codeplex.com/wikipage?title=Deploy%20SSIS%20PackagesArthur My Blog
October 3rd, 2011 11:12am

Hi Ravi, SSIS package use Config files to get values of package properties when package runs you cannot deploy package using config files you can only provide values to package when it runs using config files so suppose you have developed one package in dev. environment and when you want to deploy it to production so obvious environment values like DB connection string will be change that changeable values you can provide using config files when you deploy package. see this article http://msdn.microsoft.com/en-us/library/cc895212.aspx Now to other question how to deploy package ? for Deployment use manifest file .. see below links link1 link2 hope it make sense.. Shailesh, Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 11:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics