Share via

SSIS package running fine from SSDT but not running from SQL Server 2019

Kiritkumar Baraiya 1 Reputation point
2021-01-28T05:50:40.75+00:00

Hello,

SSIS package running fine from SSDT but not running from SQL Server 2019. I had tried all solution from internet but did not get any solution from it.

Source and destination is oracle and SSIS package running from SQL Server 2019 Datacenter edition.
61321-ssis-error.png

Can someone please provide the solution.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,895 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,331 Reputation points
    2021-01-28T06:44:23.837+00:00

    The screenshot is to small to see anything.

    If it runs in SSDT (= 32 bit app), but not as Agent-job for SSIS (64 bit), then it's often a 32/64 bit architecture problem; in job step set "Use 32 bit runtime" option and try it again.

    0 comments
  2. Kiritkumar Baraiya 1 Reputation point
    2021-02-10T05:55:15.787+00:00

    Here is the full error massage.

    0 comments
  3. Monalv-MSFT 5,896 Reputation points
    2021-02-24T02:53:57.74+00:00

    Hi @Kiritkumar Baraiya ,

    1.Please check if we can test the connections in source and destination correctly.

    2.Please set SSIS logging to get more execution info in SSIS package in SSDT.

    3.We can also to Add error flow redirection to get error data in Data Flow Task in SSDT.

    Best regards
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments