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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 DelayValidation?

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 table
loads the difference with timestamp end of the row
drops the temp table

It 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?

Thanks
Cipriani
   

- Advertisement -