Microsoft Developer Network > 포럼 홈 > SQL Azure — Getting Started > SSIS Import Export Wizard's failure to overwrite database
질문하기질문하기
 

답변됨SSIS Import Export Wizard's failure to overwrite database

  • 2009년 6월 12일 금요일 오전 9:39Krubs33 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    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.

답변

모든 응답