0

I have downloaded SQL Server 2016 evaluation onto a Windows 10 laptop. I have imported some data into a new DB and new table.

So far so good.

I have exported the data to a CSV file and save this as a SSIS package

The CSV gets produced fine.

I got SQL Server Agent and create a new job where the first and only step is of type SSIS package. I have tried switching 32 bit runtime on and off but no matter what I seem to do, I get the following error message:

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 13.0.5026.0 for 32-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 10:21:56 PM Error: 2019-10-02 22:21:57.33 Code: 0xC0048020 Source: Data Flow Task 1 Data Flow Task 1 (SSIS.Pipeline) Description: The version of Destination - 021019_csv is not compatible with this version of the DataFlow. End Error Error: 2019-10-02 22:21:57.74 Code: 0xC0048020 Source: Data Flow Task 1 SSIS.Pipeline Description: The version of Destination - 021019_csv, clsid {44152846-E5A6-4EDB-8B8E-7072209A7662} is not compatible with this version of the DataFlow. End Error Error: 2019-10-02 22:21:57.76
Code: 0xC0048021 Source: Data Flow Task 1 Destination - 021019_csv [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 SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1". End Error Error: 2019-10-02 22:21:57.77 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: Destination - 021019_csv failed validation and returned error code 0xC0048021. End Error Error: 2019-10-02 22:21:57.77 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2019-10-02 22:21:57.77 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: 10:21:56 PM Finished: 10:21:57 PM Elapsed: 1.234 seconds. The package execution failed. The step failed.

When I view connection properties it's using MSDB but I doubt this is the issue.

Any ideas?

0

Per Kraaitje on this thread, removing the

version="1"

(but not the right bracket) via a text editor allowed the package to run for me.

  • You may want to add more details to your answer, as it will become difficult to understand when the link goes stale. – mustaccio Oct 16 '19 at 0:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.