Paul Hernández (3/14/2013)

---

Hi Phil,

It was a language mistake due to my level of English, which sometimes is not good enough 😀

You are right; the correct term is “temporary”

Thanks for your...

Evil Kraig F (3/13/2013)

---

Most likely they're validating. Turn on Delay Validation.

Also, make sure you're using what's become a defacto standard for SSIS called procs:

SET NOCOUNT ON;

SET FMTONLY OFF;

WHILE 1=0

BEGIN

--...

Paul Hernández (3/14/2013)

---

Hi Phil,

Thanks for your quick answer.

Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I...

Have you thought about doing the lookups in sequence, regardless of blank value or not, and setting the 'Specify how to handle rows with no matching entries' property of the...

Paul Hernández (3/14/2013)

---

Hi Folks,

I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target...

daniel-johnsson (3/8/2013)

---

Hi Phil,

Yes that is exactly what I want to accomplish. Basically that I have Audit_ID with identity (1,1) that works as a PK in my Audit table and

my respective...

daniel-johnsson (3/7/2013)

---

Thank you for your reply Paul.

I'm using SQL Server 2012 (SP1), Developer Edition.

I use a OLE DB source to extract some data from 3 different tables from a...

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?