Forum Discussion
Schedule an SSIS package
This is the error message for Job Step. My ODBC destination driver (snowflake) is also 64 bit . How to fix this can you provide the solution?
Log Job History (Snowflake_Job)
Step ID: 1
Server : DESKTOP-2B7TI5T
Job Name :Snowflake_Job
Step Name : AR
Duration 00:00:30
Sql Severity 0
Sql Message ID 0
Message
Executed as user: DESKTOP-2B7TI5T\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 9:27:51 PM Package execution on IS Server failed. Execution ID: 65, Execution Status:4. To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report Started: 9:27:51 PM Finished: 9:28:21 PM Elapsed: 29.609 seconds. The package execution failed. The step failed.
Thanks
To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report
chvnpradeep2492 , so the package is stored in SSISDB? Then do what the message says and review the package execution report.
Olaf
we went through the error message and we are getting like below image.
Can you suggest where we fix this problem?
chvnpradeep2492 I still can only guess and if it works in SSDT/Visual Studio as 32 bit tool, but not as Agent job, then it's may a 32/64 bit issue.
Try to run the job as 32 bit, see
SQL Server Agent Jobs for Packages - SQL Server Integration Services (SSIS) | Microsoft Docs
=> 32-bit runtime
Olaf
- Hi Olaf,
As you told I validate the packages and execute the packages then those are running without errors. After creating a job & schedule a job we getting that issue so we want to schedule those job steps how can we do that? Can you provide a solution for this?
Thanks