Click here to Skip to main content
15,122,559 members

Comments by Member 8607591 (Top 3 by date)

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