SSIS Package Failing: Version of the Flat File Destination is not compatible with this version of the data flow
0
votes
1
answer
261
views
Built a simple SSIS package that pulls data from six SQL tables and dumps out to flat files. Package works fine within Visual Studio but keep getting the error code 0xC0048021 when deploying within SSMS..
This is the main error
> Data Flow Task:Error: 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 SQL Server; (C) Microsoft Corporation; All
> Rights Reserved; http://www.microsoft.com/sql/support;1 ".
I tried both CSV and TXT and both fail, RAW file destination **does** work.
SQL 2016 and the package has been built in Visual studio 2019.
I have changed the config properties for the target server version to SQL 2016 as per image
SSMS is version 20.2.30
SSIS Service is running as the local NT Service
Any advice or suggestions to try would be appreciated.
I am playing around with error capture now see if that helps.

Asked by Stockburn
(501 rep)
Feb 13, 2025, 12:00 AM
Last activity: Feb 13, 2025, 01:47 AM
Last activity: Feb 13, 2025, 01:47 AM