Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-06-01 : 07:46:20
|
Hi,Im performing the following:Dataflow task:Reads from access table,checks if temp already exists then creates it,loads all that is read from the access file to the temp table.Container: It checks the difference between the destination table and the temp tableloads the difference with timestamp end of the rowdrops the temp tableIt shows an error when it runs the process again, saying check the temp table exists, ive looked into possible solutions using delay validation but maybe its not best? anyone can provide any help?ThanksCipriani |
|
|
|
|