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 ...
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy