SSIS package with Flatfile output

Srinivas K 21

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

Accepted answer

Yitzhak Khabinsky 26,201 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.
Please sign in to rate this answer.
Srinivas K 21 Reputation points

2020-10-29T21:03:09.75+00:00

I tried adding some variables and a Filesystem task to rename file generated with the Dataflow task and now the Dataflowtask is again failing with the same error which worked earlier.

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

any suggestions?

Yitzhak Khabinsky 26,201 Reputation points

2020-10-29T21:18:36.623+00:00

Is it happening on the dev. machine in VS2019, or in the SSIS run-time environment on the server?

Srinivas K 21 Reputation points

2020-10-30T12:29:30.783+00:00

It is working on my machine but failing when deployed on DB server.

Yitzhak Khabinsky 26,201 Reputation points

2020-10-30T14:58:17.747+00:00

Please copy .ispac file from the dev. machine to the server with SSIS, and deploy it locally in the SSMS.

Srinivas K 21 Reputation points

2020-10-30T21:18:43.217+00:00

Thank you, I am working with our DBA for the access to deploy the package using .ispac on DB server.

Srinivas K 21 Reputation points

2020-11-02T15:06:16.3+00:00

I deployed the package on DB Server using .ispac but still getting the same error i.e. The version of Flat File Destination, clsid{44152846-E5A6-4EDB-8B8E-7072209A7662} is not compatible with version of DataFlow.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

2 additional answers

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?
Please sign in to rate this answer.
Yitzhak Khabinsky 26,201 Reputation points

2020-10-02T20:49:07.803+00:00

As I already pointed out, 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 Server 2016

I am obviously unaware about any extensions in your environment.

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.
Useful link: SQL Server Integration Services Projects

Srinivas K 21 Reputation points

2020-10-02T21:14:03.313+00:00

Yes I set the Target ServerVersion property yo SQL Server 2016 and I have VS 2019 Professional and latest SSIS was installed from Market place.

Yitzhak Khabinsky 26,201 Reputation points

2020-10-02T21:26:37.877+00:00

I updated my previous comment with the latest versions for both.
Please try to re-deploy the SSIS project to SSIS run-time environment on the SQL Server 2016 server.

Srinivas K 21 Reputation points

2020-10-02T21:34:43.447+00:00

Yes, I deployed the SSIS package after changing the TargetServerVersion to SQL Server 2016 and getting the error.
Also found that the same is working when created the package in Visual Studio 2017. so wants to know what will be the issue using VS 2019 for SSIS packages going further as we are moving from VS2017 to VS2019.

Yitzhak Khabinsky 26,201 Reputation points

2020-10-02T21:40:29.307+00:00

You never confirmed what versions you are running...

Srinivas K 21 Reputation points

2020-10-05T13:36:22.81+00:00

I have the below versions

Visual Studio 2019 version16.5.4

SSIS extension 3.10

I created new SSIS Project with Target SQL Server version as SQL Server 2016 and Imported the project into SSIS catalog, which was failed. Also tried setting Target SQL Server version as SQL Server 2017 and still it failed with error mentioned.

Do we need to install SSIS extension 3.10 on SQL Server 2016?

Yitzhak Khabinsky 26,201 Reputation points

2020-10-05T14:16:25.067+00:00

You need to install VS2019 (v.16.7.5)

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

Additionally, you can copy *.ispac file from the dev. machine with Visual Studio on it to the SSIS run-time server, and deploy it there directly in the SSIS Catalog.

Srinivas K 21 Reputation points

2020-10-05T14:21:24.247+00:00

Thank you, let me try upgrade my VS2019 to (v.16.7.5).

Srinivas K 21 Reputation points

2020-10-05T16:12:23.457+00:00

Thank you @Yitzhak Khabinsky ,

Upgrade of VS2019 to v.16.7.5 got worked.

Yitzhak Khabinsky 26,201 Reputation points

2020-10-05T16:45:20.837+00:00

Glad to hear that the proposed solution worked for you.
IMHO, you made a mistake by marking your reply as an Answer.
You need to click 'Accept Answer' for my Answer.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Cris Zhan-MSFT 6,641 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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSIS package with Flatfile output

2 additional answers

Your answer