hi guys, am new to editing SSIS packages in VS2010 so any pointers would be helpful and more specifically for my problem.
I am importing data from 1 database to another. It is currently a 3 step process, 1st step creates database and tables, 2nd step loads data into those tables and 3rd step applies constraints.
If I execute each step in turn it works fine.
If I run the package it does not and I get the error shown.
I believe this is happening because my Destination as defined by DestinationConnectionOLDDB
and tables referenced by Load Data do not exist at the point of clicking execute package.
What should I be doing to handle this scenario?