Looks to me like your delete query is not sophisticated enough and will leave behind orphaned records - except your referential integrity rules are currently stopping that. Be careful.

niffer76 (7/23/2010)

---

I am still struggling with this a bit. I have set up the ForEach loop container to pick up the files based on the file name using "*"...

You'll need three dataflow tasks.

That does not mean that you need three packages. You can chain from one DF to another, or run them in parallel, within the same package.

Are you saying that...

That article refers to an import to SQL Server, not an export to Excel.

Can you try explaining what's going on?

Why do the INSERTs fail?

I don't see how - that expression looks only at the first letter of [Copy of Description] whereas your query does much more.

To me, yours looks equivalent to this:

(SUBSTRING([Copy of...

Try using the import / export wizard.

What was the query and what was the error?

Are you using DB2 syntax or T-SQL syntax?

That's a better way of identifying your source data - every record will result in an INSERT...

For each record in your source, check for existence (match on PK) in destination. In pseudo code:

If Exists ...

I agree - what are your findings? A single quote in one of the fields perhaps?

Yes, definitely. You will have to re-do your development in 2005. There is no 'Save As' function.

Probably a permissions issue relating to the credentials used when the job is executed.

Same as my solution!