July 5, 2007 at 8:03 am
Hi,
I used SQL Server Business Intelligence Development Studio and created a new SSIS package. I have transfer login task & copy database task. The first step runs fine, but for the later I am getting "DROP DATABASE DBName" failed, although no one is using that database.
How do I fix this issue, here is the error.
Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "IF EXISTS (SELECT name FROM sys.databases WHERE name = N'DBName') DROP DATABASE [DBName] " failed with the following error: "Cannot drop database "DBName" because it is currently in use.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter.
It gets weird, when this error is thrown (in debug mode), I stopped the package. When checked the data, all the tables have been created and the data has been updated.
Thanks.
-R
July 6, 2007 at 9:32 am
It's a known issue, (although I am using SP2) I am still having this issue.
Found an alternate solution, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=473590&SiteID=1
February 7, 2013 at 11:54 pm
not able to open link
February 8, 2013 at 3:54 am
Vikas Pathak (2/7/2013)
not able to open link
That link is from 2007 - perhaps MS have modified their web site in the last six years ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 10, 2013 at 10:21 pm
Sorry! I am not able to open the given link.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply