SSIS Import Export Wizard's failure to overwrite database

Question

Hi,

I am using SSIS import export wizard to overwrite database.

It has created a very complicate package that I can't more understand.

When I run that package for the first time to copy database , it worked good but when I have tried to overwrite same database I got following error

Error: 0xC002F210 at PrologueSql, Execute SQL Task: Executing the query "" failed with the following error: "". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: PrologueSql
Task failed: CompensatingSql
SSIS package "Package1.dtsx" finished: Failure.

I don't know how to solve this, can anybody look into this as it's too important to work for this package.

Your effort will be appreciated, n thanks in advance.

Answer 1

This forum is for SQL Data Services, a Microsoft's Cloud database service offering. You will have a better chance of getting a fast answer in one of the SQL Server specific forums: http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&SiteID=1  

Thanks
 Kapil