Error when the table has not created yet

Question

Error when the table has not created yet

fasttrack

SSCertifiable

Points: 6071
More actions
August 28, 2007 at 7:43 pm

#120189

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Baskar B.V SSCrazy Points: 2823 More actions · Answer 1

Hope this error happens during validation stage.

Make 'Delay Validation' property of the data flow task to True at Design time and run the package. This would wait till run time and your package would create the create before it execute the data flow task.

HTH

[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

fasttrack SSCertifiable Points: 6071 More actions · Answer 2

Hello,

thank for your reply.

The solution works fine.

Question:

Making ''Delay Validation' property' as true in case of modification of package they are in any case saved.

Any other problem is detected with the property set 'true' or I risk to loose any useful information that affect the execution of package in prodution?

Thank

Eric SSCommitted Points: 1803 More actions · Answer 3

A risk of delaying validation is a package may have many tasks and one of the final tasks may fail due to a missing dependency. Instead of the package failing when it first opens and before it had a chance to modify any data now it won’t fail until it hits the task with the missing dependency. This can make it more difficult recover from a failure since data may have been modified.

Baskar B.V SSCrazy Points: 2823 More actions · Answer 4

Making delay validation to true is just delaying the validation till runtime. This property would be useful when designing/building packages through BIDS.

What happens in a typical scenerio is when a package is opened or built in BIDS it starts validating the tasks. By setting the property we are saying that delay the validation until runtime. So when the package is executed it does validation of all tasks before starting running any of the tasks. So in Eric scenerio the package should fails at the first point itself bcoz the last task has a missing dependency. It would not run all the tasks from the beginning and fail at the last task.

Hope i am correct. Let me know your inputs on this.

[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

Dan Colbert-387424 SSCrazy Points: 2195 More actions · Answer 5

Is there a reason you are dropping and recreating the table? Why don't you leave the table there and just TRUNCATE it?

I'm always hesitant to turn off validation if I can help it.

fasttrack SSCertifiable Points: 6071 More actions · Answer 6

hi,

thank all for your contribution.

Yes, the truncate table that I have already thought may be another solution.