none
Error if table has not created yet at the first time RRS feed

  • Question

  • Hello,

     

    I have created a package that check if a table exist otherwise it drop it, then it creates a new one (both with SSIS execute SQL task).

    Then a Flow task run some transformation SSIS to load the table just created.

    The problem is that when I run the package an error occur telling me that the table does not exist (if runs for the first time and in this case the table has not created yet).

     

    How can I run a package that create a table and then Load it.

     

    Thank

    Wednesday, August 29, 2007 1:34 AM

Answers

  • You need to set the DelayValidation property to True on the Data Flow and the Execute SQL tasks.

     

    Wednesday, August 29, 2007 1:42 AM
    Moderator