Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Package fails if table doesn't exist
Message
From
12/12/2011 05:28:02
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Package fails if table doesn't exist
Miscellaneous
Thread ID:
01530840
Message ID:
01530840
Views:
76
Hi

I've created a package to process some data and send out some results.

Part of the package creates a tempdb table which is used in a subsequent step to import a csv file.

If the server has been restarted since the packages last run the tempdb file doesn't exist and the package fails because of the missing file.

How can I prevent the package checking for the existence of this file before it starts as I'm going to create it anyway if its not there.

Thanks

Nick
Next
Reply
Map
View

Click here to load this message in the networking platform