Run SSIS package using a Job

Question

I have an SSIS job that runs fine in design mode. However when I try to run it through a SQL Server Job by calling the dtsx it fails with the following message:

Executed as user: DOMAIN\USER_ACCOUNT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.1000.169 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 9:18:32 PM Error: 2021-01-10 21:18:32.63 Code: 0xC0048020 Source: Data Flow Task 1 Data Flow Task 1 (SSIS.Pipeline) Description: The version of Flat File Destination is not compatible with this version of the DataFlow. End Error Error: 2021-01-10 21:18:32.73 Code: 0xC0048020 Source: Data Flow Task 1 SSIS.Pipeline Description: The version of Flat File Destination, clsid {0667D728-1E5F-4BB6-863D-B29D3F405706} is not compatible with this version of the DataFlow. End Error Error: 2021-01-10 21:18:32.73 Code: 0xC0048021 Source: Data Flow Task 1 Flat File Destination [2] Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Flat File Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2021-01-10 21:18:32.73 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: Flat File Destination failed validation and returned error code 0xC0048021. End Error Error: 2021-01-10 21:18:32.73 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2021-01-10 21:18:32.73 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:18:32 PM Finished: 9:18:32 PM Elapsed: 0.266 seconds. The package execution failed. The step failed.

The package was created by DOMAIN\USER_ACCOUNT and the SQL Server Agent Service Account is also running under DOMAIN\USER_ACCOUNT.

Thanks!

Answer 1

Hi @scott Hanebutt ,

Please edit your question and add the following information:

• Visual Studio version.
• SSDT or SQL Server Integration Services Project extension (for VS2019) version.
• TargetServerVersion in the VS SSIS project.
• SQL Server instance version on the SSIS run-time server.
  via SELECT @@VERSION; in SSMS

Overall, you need to make sure that the TargetServerVersion is matching the SQL Server instance version.

Please see below.

Answer 2

Hi @scott Hanebutt ,

1.Could you please share the version of SQL Server where you run the job?

2.Please check if you set the TargetServerVersion property correctly.
We can refer to Version targeting in Integration Services projects.

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.