This is a common problem: Use a dtsx package with dynamic database connection. In fact there are times that you need to set connection string of database from outside of package. solution: Suppose that you have an OLE DB connection and set it to same database which you want to work with and named it Read more about Dynamic connection string in SSIS[…]