DTEXEC.EXE command line - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

DTEXEC.EXE command line

Author

Topic

tboonleong
Starting Member

24 Posts

Posted - 2011-11-04 : 05:12:44

exec master..xp_cmdshell 'DTEXEC.EXE /DTS "\MSDB\New Package" /SERVER myIPaddress /CHECKPOINTING OFF /REPORTING E '
OR
exec master..xp_cmdshell 'DTEXEC.EXE /SQL "New Package" /SERVER myipaddress /CHECKPOINTING OFF /REPORTING E '

I had tried above 2 methods at the SQL server (MS sql 2008 R2) named as New Package and it hit the error as below :

Microsoft (R) SQL Server Execute Package Utility
Version 10.50.2425.0 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
NULL
Started: 2:49:37 PM
Error: 2011-11-04 14:49:37.68
Code: 0xC0040044
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: Failed to set the XML persistence events property for the Data Flow objects.
End Error
Error: 2011-11-04 14:49:37.68
Code: 0xC0040041
Source: Data Flow Task Data Flow Task (SSIS.Pipeline)
Description: Failed to load Data Flow objects
End Error
Error: 2011-11-04 14:49:37.68
Code: 0xC0010018
Source: Data Flow Task
Description: Failed to load task "Data Flow Task", type "SSIS.Pipeline.2". The contact information for this task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microso
ft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
End Error
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 2:49:37 PM
Finished: 2:49:37 PM
Elapsed: 0.187 seconds
NULL

Anyone have any idea regarding to the above error?

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-11-06 : 15:46:46

what exactly are you doing in the ssis package. that error is very misleading in that a totally different issue might spit out a totally unrelated error. Could be helpful to know what exactly you are doing in ssis package.

If you don't have the passion to help people, you have no passion

tboonleong
Starting Member

24 Posts

Posted - 2011-11-09 : 02:14:25

I use the import and export tool in management studio and save it into the ssis server and then use the above command line to execute the ssis package at the ssis server.

Any other information may help to clarify, please let me know.
Becacuse I already dont know what I cna do on this problem.
Appreciate any help. Thanks.

p/s: I had test it on my PC with sql server 2008 32 bit then it run ok.

The server is runing at sql server 2008 R2 with 64 bits and hit the above error.

Does it related to the bit of the server?

tboonleong
Starting Member

24 Posts

Posted - 2011-11-09 : 03:49:38

Thanks for all reply.

It is server bit issue.

http://msdn.microsoft.com/en-us/library/ms162810.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources