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...
olafhelper's avatar
olafhelper
Bronze Contributor
Mar 22, 2022

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
    Mar 22, 2022

    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