SQL Server Performance Forum – Threads Archive
giving connection strings in variables,expressionI have created a SSIS package in the visual studio i used connection manager for all my tasks but now I want to use variables for my server connections and local paths etc.. , rather than using connection manager to avoid migration problem from server to server.
Can we use expressions also for this purpose then kindly show me a example. I want to use this package as a scheduled job in sql server. And i want to know various deployment methods available for a package in sql server.
Read about creating configuration files with SSIS package where you can specify the connection parameter at runtime.