March 27, 2008 at 6:11 am
Hi,
Iam creating a package to import a query from db2 to sql server.
I need to truncate the table in the destination while I create the package?
can I use import/export wizard for this or I need to use Designer?
could you plz tell me how to do this? what are the tasks I need to consider/
thanx
March 27, 2008 at 7:06 am
You would need to use the designer. I typically use an Execute SQL Task to truncate the destination table. Then use a Data Flow Task for creating the import porcess. On the control flow tab you would have an On Success Precedent Constraint from the Execute SQL Task to the Data Flow Task.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 27, 2008 at 7:18 am
hi,when iam creating precedent contraint it says "can not create a connector only one work flow can exist between the two same executable"?
could plz tell me wat to do
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply