I have SSIS file *.dtx which works on test machine with test sql server and works locally started with production/test sql server. When the file is moved to production machine and started with production machine (no change of credection in SSIS file) it fails with message in event log: Source SQLISPackage120, Event ID: 12291.
The logging is turned on: with works everywhere except production machine. It logs also when SSIS file is started locally from VS but with production database.
How to find more information about problem?
UPDATE1:
I found in SQL Agent log file entry:
Login failed for user 'aaa'. Reason: Password did not match that for the login provided. [CLIENT: ...]
How to configure windows user to be able to run SSIS task (or to be able to log in SQL server from SSIS)?
The real problem was that user defined in SSIS's connection string had no access to production's database called XXX.
The most important information were found in SQL Server log file: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\errorlog