Between source and destination.

Nice solution Jeff.

That's not as easy as you've made it sound - unless you know a method I haven't thought...

--Oops, please ignore!

John Rowan (11/6/2009)

---

Good to hear that you're up and running Tim. I agree, it's simple when you know how, but I'm not sure I'd call using a script task...

I already thought that SSIS was tough enough in English, but this takes it to another level 😀

Looks like a problem on the AS/400 side - can you give more...

I have a couple of Excel suggestions for you:

1) When entering numeric data that you want to to be treated as text, enter a single quote as your 1st character....

Can you post the exact syntax of your expression field - sounds like it may need a tweak.

You have made a statement without asking a question, leaving us to guess.

Are you saying that the problem does not happen unless you are in debug mode, or is it...

Formatting as text does not affect how Excel holds data.

Specifically, if you format a number as text in Excel and then import it, it will still come in as a...

Beat ya! 🙂

Create a derived column & set it to the value of your variable before firing through data conv ...

One guess would be that your PK data in Excel is in numeric format and that your PK on SQL Server is held as varchar(n) (even though it may look...

In your Dataflow, there's a Data Flow Transformation called 'Lookup' - that's the one I was referring to. Have fun learning 🙂

Add a look-up to check whether the PK from your source already exists in your target data. If not, do the create, otherwise ... nothing.