Forum Discussion
Schedule an SSIS package
Hi team, I created multiple packages in SSIS. Source connection manager is Excel/ Oracle Database and Target connection manager is ODBC(Snowflake cloud) so we created packages and containers. Now...
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