SSIS package with Flatfile output

Srinivas K 21 Reputation points
2020-10-02T19:57:47.33+00:00

Hello,

I created a new SSIS package in Visual Studio 2019 to execute an SQL and write the results to a text file. it is working fine when executing the package in Visual studio 2019 but when deployed in SQL server 2016 it is failing with the below error.

Data Flow Task Error: The version of Flat File Destination, clsid{44152846-E5A6-4EDB-8B8E-7072209A7662} is not compatible with version of DataFlow.

Appreciate any help on this.

Regards,
Srinivas

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,324 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,417 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 24,726 Reputation points
    2020-10-02T20:22:58.45+00:00

    You need to make sure in VS2019 that the TargetServerVersion property setting value on the project level is matching your SSIS run-time version, i.e. SQL Server2016

    Please make sure that you are running latest versions of both (1) VS2019 (v.16.7.5) and (2) SQL Server Integration Services Projects for VS 2019 (v.3.10). The (2) is an extension for VS2019.

    There is no need to install SSIS extension 3.10 on the SQL Server 2016 side. It is just for Visual Studio.

    29888-ssis-targetserverversion-2.png


2 additional answers

Sort by: Most helpful
  1. Srinivas K 21 Reputation points
    2020-10-02T20:36:26.733+00:00

    thank you for your reply. I already tried setting the TargetServerVersion to SQL server 2017 and also SQL server 2016 but no luck. here is the message I got when changed the TargetServerVersion to SQL Server 2017 or SQL server 2016. do we need to install any thing on SQL Server 2016?29917-ssiswarningmessage.jpg


  2. Cris Zhan-MSFT 6,601 Reputation points
    2020-10-05T06:22:40.047+00:00

    Hi @Srinivas K ,

    Is there any update on this case?

    Here is a similar post.
    https://stackoverflow.com/questions/61083424/ssis-catalog-package-error-version-of-flatfile-destination-not-compatible-with


    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 No comments