Hi,<br/> <br/> I am using SSIS import export wizard to overwrite database.<br/> <br/> It has created a very complicate package that I can't more understand.<br/> <br/> 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<br/> <br/> Error: 0xC002F210 at PrologueSql, Execute SQL Task: Executing the query &quot;&quot; failed with the following error: &quot;&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly.<br/> Task failed: PrologueSql<br/> Task failed: CompensatingSql<br/> SSIS package &quot;Package1.dtsx&quot; finished: Failure.<br/> <br/> I don't know how to solve this, can anybody look into this as it's too important to work for this package.<br/> <br/> Your effort will be appreciated, n thanks in advance.© 2009 Microsoft Corporation. All rights reserved.Wed, 17 Jun 2009 18:40:22 Ze2bd031e-3de6-42e0-9db7-5f03092c622ehttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/e2bd031e-3de6-42e0-9db7-5f03092c622e#e2bd031e-3de6-42e0-9db7-5f03092c622ehttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/e2bd031e-3de6-42e0-9db7-5f03092c622e#e2bd031e-3de6-42e0-9db7-5f03092c622eKrubs33http://social.msdn.microsoft.com/Profile/en-US/?user=Krubs33Hi,<br/> <br/> I am using SSIS import export wizard to overwrite database.<br/> <br/> It has created a very complicate package that I can't more understand.<br/> <br/> 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<br/> <br/> Error: 0xC002F210 at PrologueSql, Execute SQL Task: Executing the query &quot;&quot; failed with the following error: &quot;&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly.<br/> Task failed: PrologueSql<br/> Task failed: CompensatingSql<br/> SSIS package &quot;Package1.dtsx&quot; finished: Failure.<br/> <br/> I don't know how to solve this, can anybody look into this as it's too important to work for this package.<br/> <br/> Your effort will be appreciated, n thanks in advance.Fri, 12 Jun 2009 09:39:26 Z2009-06-12T09:39:26Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/e2bd031e-3de6-42e0-9db7-5f03092c622e#9a3b6461-22a7-4a35-984a-b806f453488dhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/e2bd031e-3de6-42e0-9db7-5f03092c622e#9a3b6461-22a7-4a35-984a-b806f453488dKapil Muni Guptahttp://social.msdn.microsoft.com/Profile/en-US/?user=Kapil%20Muni%20Gupta<br/>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: <a href="http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&amp;SiteID=1"><span style="color:#0033cc">http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&amp;SiteID=1</span></a>  <br/><br/>Thanks<br/> KapilFri, 12 Jun 2009 10:22:02 Z2009-06-12T10:22:02Z