dtexec failed when run package from command line with

Redouane Mejdi 1 Reputation point
2021-03-24T14:39:00.41+00:00

****I have SQL Server Management Studio 15 installed on my machine, I created a dtsx package. This package works perfectly in UI mode. but when i run it from command line i get the following error message:**** Started: 10:21:49 Error: 2021-03-24 10:21:49.54 Code: 0xC0040019 Source: Tâche de flux de données 1 Tâche de flux de données 1 (SSIS.Pipeline) Description: Data Flow objects cannot be loaded. Check if Microsoft.SqlServer.PipelineXml.dll is properly registered. End Error Error: 2021-03-24 10:21:49.54 Code: 0xC0010018 Source: Tâche de flux de données 1 Description: Failed to load task "Tâche de flux de données 1", type "SSIS.Pipeline.7". The contact information for this task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2021-03-24 10:21:49.56 Code: 0xC001F02A Source: DD9482 - ExtractionUniteStructurelle_TEST Description: Cannot create a task from XML for task "Tâche SQL de préparation 1", type "Microsoft.ExecuteSQLTask" due to error 0x80070057 "Paramètre incorrect.". End Error Error: 2021-03-24 10:21:49.56 Code: 0xC0010018 Source: Tâche SQL de préparation 1 Description: Failed to load task "Tâche SQL de préparation 1", type "". The contact information for this task is "Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2021-03-24 10:21:49.56 Code: 0xC001F02A Source: DD9482 - ExtractionUniteStructurelle_TEST Description: Cannot create a task from XML for task "Tâche SQL de suppression de table(s) 1", type "Microsoft.ExecuteSQLTask" due to error 0x80070057 "Paramètre incorrect.". End Error Error: 2021-03-24 10:21:49.56 Code: 0xC0010018 Source: Tâche SQL de suppression de table(s) 1 Description: Failed to load task "Tâche SQL de suppression de table(s) 1", type "". The contact information for this task is "Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2021-03-24 10:21:50.49 Code: 0xC0010026 Source: Tâche SQL de préparation 1 Description: The task has failed to load. The contact information for this task is "Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". End Error Error: 2021-03-24 10:21:50.49 Code: 0xC0024107 Source: Tâche SQL de préparation 1 Description: There were errors during task validation. End Error Error: 2021-03-24 10:21:50.49 Code: 0xC0010025 Source: DD9482 - ExtractionUniteStructurelle_TEST Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:21:49 Finished: 10:21:50 Elapsed: 1.297 seconds

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,709 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,946 Reputation points
    2021-03-24T16:49:24.893+00:00

    Hi @Redouane Mejdi ,

    To run SSIS on a dev. machine outside of Visual Studio, you need SSIS run-time installed.

    SSIS has two principal environments:

    • Development environment on a dev. machine, with Visual Studio and SSDT (or SQL Server Integration Services Projects extension for VS2019).
    • Run-time environment on a server, with SQL Server instance plus SSIS run-time installed.

    P.S. Please add Integration Services (SSIS) tag to your post.

    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2021-03-25T08:43:18.207+00:00

    Hi @Redouane Mejdi ,

    1.Please check if you set protection level in the ssis package in SSDT.
    To protect the data in an Integration Services package, you can set a protection level that helps protect just sensitive data or all the data in the package. Furthermore, you can encrypt this data with a password or a user key, or rely on the database to encrypt the data.

    2.Please check if you install Integration Services (SSIS).
    Please refer to Installing SQL Server Integration Services.

    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.