July 15, 2009 at 2:53 pm
Need to find a command or script to drop SSIS packages from production environment.
As I need to drop 25 packages, there might be a chance to drop the wrong one, if I use GUI wizard.
I am looking for a command or command line statement that will take the names of SSIS packages as Input and will perform drop action.
Thanks for your help.
July 15, 2009 at 3:07 pm
You might try:
dtutil /SQL PackageToDeleteName /DELETE
CEWII
July 15, 2009 at 3:11 pm
From the package store:
dtutil /DTS PackageToDelete.dtsx /DELETE
CEWII
July 16, 2009 at 9:58 am
Thanks for your help , but it failed at my ena, but works out with another parameter..
failed like below ..
<<dtutil /SQL TestPackagedel /Del
Microsoft (R) SQL Server SSIS Package Utilities
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2004. All rights reserved.
Error (0xC0014013) deleting package "TestPackagedel" from SQL Server.
Description: The RemoveFromSQLServer method encountered OLE DB error code 0x800
4005 (Login timeout expired) The SQL statement that was issued has failed.
Source:
>>>>>
Successful with below commands by adding source ..
C:\Documents and Settings\a472797>
[font="Arial"]dtutil /SQL TestPackagedel /DELETE /SourceS [/font]
Microsoft (R) SQL Server SSIS Package Utilities
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2004. All rights reserved.
The operation completed successfully.
July 16, 2009 at 9:04 pm
Great, I'm glad it worked for you, even though you had to tinker a bit..
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply