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!

da-zero (7/15/2010)

---

No, that is only necessary when the field name contains a space.

I think he forgot the initial...

OK, I understand what you mean.

I'd be tempted to use ranking functions to assign a row number (order by ID, or whatever you want) to each row in both tables,...

You left out the square brackets around the field name ...

That will do...

Please provide sample input data, along with desired output data.

The general solution to this sort of problem is to import the entire row into a single big varchar field and then break it up into your required fields as...

Vernon Jimmerson-306463 (7/14/2010)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is...

I'd leave it as int and add a char(4) derived column...