October 2, 2012 at 7:17 am
Windows batch file executions do not fail within SSIS when SSIS run using DTExec
The account we are using to execute the jobs is a local admin on the server
The jobs ran successfully in the past, but have been failing for 2 weeks
We are running SQL Server 2008 R2 on a 64-bit server. We had a successful job execution when we ran the job using 32-bit mode while trying to solve the problem.
The specific batch job that fails maps drives to allow access to a password protected folder so we may resolve the “file connection string” in the connection manager.
Anybody have any thought on this?
October 31, 2012 at 4:43 pm
Open the SQL Agent job and the step where you call the SSIS Package.
On the "Execution Options" tab...check the box "Use 32 bit Runtime" and see what happens. When using Excel or some ODBC drivers you need this setting to emulate the 32-bit environment or the job will fail.
-Eric
November 1, 2012 at 7:29 pm
Thanks of the suggestion. We aleady tried running the job in 32-bit mode via the job agent.
The big picture is that we have to connect to password protected Samaba folders to retrieve files. We need to map drives(shares) with the password to resolve the connection string in the flat file connection manager. Ultimately the issue was that the batch job was mapping letter drives and as the batch file was getting reused from different developers, either the letter drives eventually ran out, or the letter drive was already mapped and the batch job failed.
The solution was to rewrite the batch file more intelligently.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply