Forum Discussion

chvnpradeep2492's avatar
chvnpradeep2492
Copper Contributor
Mar 22, 2022

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 want to schedule those.

I tried by deploying a project in SSMS and by creating a new job. In the job, I added job steps and gave a schedule time. Every time it is getting failed due to the below error. If I use target connection manager OLE DB(SQL) I'm able to schedule the packages successfully.

 

Date 3/22/2022 9:49:16 AM
Log Job History (JOB)

Step ID
Server DESKTOP-2B7TI5T
Job Name JOB
Step Name
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message :
The job failed. The Job was invoked by User DESKTOP-2B7TI5T\Rajeswari. The last step to run was step 1 (AR).

 

Below are the SQL server management studio Details:

SQL Server Management Studio 15.0.18358.0
SQL Server Management Objects (SMO) 16.100.44091.28
Microsoft Analysis Services Client Tools 15.0.19260.0
Microsoft Data Access Components (MDAC) 10.0.22000.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22000

 

Please guide me how to achieve this with brief steps.

Thanks.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

    chvnpradeep2492 , the error message is the main one from the job; not very usefull.

    Lookup the error message details from the job step instead.

     

    Often cause of such error is a bitness confict between Agent job and data provider, e.g. a 64 bit job step using a 32 bit data provider. Is that the case here?

     

    Olaf

    • chvnpradeep2492's avatar
      chvnpradeep2492
      Copper Contributor

      olafhelper 

      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

Resources