question

RedouaneMejdi-3763 avatar image
0 Votes"
RedouaneMejdi-3763 asked Monalv-msft edited

dtexec failed when run package from command line with

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-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

Hi @RedouaneMejdi-3763,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @RedouaneMejdi-3763 ,

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RedouaneMejdi-3763 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·