June 24, 2009 at 1:53 pm
I am trying to drop pacage with below statement
drop package [Package name ]
and it is returning
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'Package name'.
Do I need to use anyother database other than msdb, in Integration services to drop the package.
June 24, 2009 at 2:15 pm
I am not sure , if any command for dropping packages except below steps
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to delete.
In Solution Explorer, right-click the package, and then click Delete.
Click OK to confirm the deletion or click Cancel to keep the package.
June 24, 2009 at 2:17 pm
Plz try this
delete packaage packagename
June 24, 2009 at 2:38 pm
connect to integration services insted of database engine and then list the packages in the left side obect explorer... right click on package and delete....
or using DTUTIL
DTUTIL /SQL (PACKAGENAME) /DELETE /SourceS (ServerName)
Maninder
www.dbanation.com
June 24, 2009 at 2:52 pm
Thanks for your response, I need to use command line as I need implement the same in multiple environments.
Now I am getting following error , and my package name is having words with spaces..
Now I am getting below error..
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>DTUTIL /SQL('PrimeDB Retrieve Current Geneva Securities') /DELETE /SourceS (FITRTP200SQL)
Microsoft (R) SQL Server SSIS Package Utilities
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2004. All rights reserved.
Option "/SQL('PrimeDB" is not valid.
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>
June 25, 2009 at 10:48 am
Omit parenthesis and put double quotes (") around the package name.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply