OK, here's one way.

1) Create an integer variable in your SSIS package - say MaxId.

2) An an ExecuteSQL task which connects to your target db (the one you are importing...

Cool - is it an ascending number?

The reason I ask: one way to do this would be to query your existing data, get max(id) and then get the new data...

How will you identify whether a customer already exists - what is the PK?

Debbie Edwards (3/6/2013)

---

Im horribly close to having to sign this off as a no can do at the moment which is really dissapointing.

From what I can gather I possibly need...

Did you follow the link in my previous post? The word 'here' is a hyperlink.

quillis131 (3/6/2013)

---

Phil Parkin (3/6/2013)

---

opc.three (3/6/2013)

---

Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing...

What got my...

What's on row 4?

If you remove that row, does the rest of the file process OK? If not, what else fails?

dwilliscp (3/4/2013)

---

Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have to set it to ServerStorage everytime I create a package. Can not...

It was indeed 🙂

What are the parameters defined as in the stored proc definition?

tota00 (3/4/2013)

---

Phil Parkin (3/4/2013)

---

Please follow the link in my signature to get details of how to post sample DDL, data and desired results to get the best response to your...

Please follow the link in my signature to get details of how to post sample DDL, data and desired results to get the best response to your question.

Are you sure that you haven't just run the package twice?

Use package configurations to control the values of things whose settings vary between environments.