Barkingdog (3/14/2013)

---

A few points:

1. Yes, these are fixed width files. The main annoyance I encountered is that SSIS would not let me define all the connections in one shot. I...

Table by table. As long as SSIS can recongnise and use the driver OK.

The Import Wizard may help speed development of your import.

daniel-johnsson (3/14/2013)

---

Hi Phil and Lynn,

I have been trying to solve my problem with your instuctions but I'm still not able to work it out I'm afraid. Maybe I am missing...

Or use MAX(Getdate()) rather than grouping by it.

You might be right. Why not try changing your getdate() accuracy to one minute to test your hypothesis?

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?