Comments by Member 8607591

Member 8607591 17-Oct-13 7:20am View

I think this article covers it but i cannot suppress the error message in the log file
http://technet.microsoft.com/en-us/library/ms141682(v=sql.105).aspx

Understanding How SSIS Package Configurations Are Applied at Run Time When you use the dtexec

Member 8607591 17-Oct-13 7:13am View

Yes the package is run via autosys which runs under a system account. The dev account only has access to the dev db and the uat account only has accesd to the uat database

Member 8607591 17-Oct-13 6:09am View

We are using sql server configuration and deploying the dtsx files to each server as we promote the packages through from dev to prod. Each database had its own ssis-config table

Comments by Member 8607591 (Top 3 by date)