Either the database with ID of " OLD_DATABASE_NAME " does not exist in the server with ID of " NEW_SERVER_NAME " or the user does not have permissions to access the object."Īs for access (username/pass) settings they are the same for both of them, I have the same administrative rights on both machines. In all cases I recieved the same error execution message : Changed exported properties - Server name, Initial Catalog and also the whole Connection String. And try to execute.Ģ) on the destination machine I manually created an OLE DB connection (using Microsoft Data Link) to a different database (test succeded), Changed the extention of the connection file 'udl' for ' txt ' and copied its connection string to the field connection string in section "Connection Managers" (pointed in variant 1) ).ģ) use Package Configurations, copied the deployment to destination machine, installed the package the way like written here. Everything worked well both in debug mode and testing package itself.įinally I need to load data to a database on a different machine using this package.ġ) simply copied the package-file to estination machine, open it for execution, in section "Connection Managers" I edited connection string manually - changed server name and Initial Catalog. For access to this database an OLE DB connection was defined within a package in BI Development Studio.
During development database was also on my machine. I create a SSIS Package for ETL on my own machine.
0 kommentar(er)
