If rows are loaded into the destination while they are actually updates, there's probably something wrong in your configuration.

Check the conditions and...

Do not do...

Grant Fritchey (3/19/2012)

---

Or just perform the MAX statement as a derived table (same thing as a CTE) and join to that. In this situation a CTE just changes the location...

If you open an SSIS project in BIDS, you can select "Work Offline" in the SSIS menu.

I don't know if it really works though...

At first sight that's because you have a correlated subquery in your SELECT statement.

For every row, the SELECT MAX(createddate) query is executed.

You can try to create a CTE that has...

In a nutshell, yes.

But as Gail mentioned, there are other reasons as well.

You...

GilaMonster (3/19/2012)

---

The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so...

I mean, did you implement it using TSQL or using the SCD component...

Elliott Whitlow (3/16/2012)

---

The suggestion of the previous poster only handles the BIDS environment.. It is not honored on the server..

What version of SQL are you using, if its 2008...

I wouldn't use an identity column as a business key.

An identity column doesn't have a "real" value to uniquely identify a row.

For example.

Table A has two records containing client info.

1,...

Elliott Whitlow (3/16/2012)

---

I would actually warn against mapping drives if there is any way to prevent it. It is far better to use UNC paths. In my experieince...

Understanding Integration Services Package Configurations

So the sheet called Header exists in your Excel file?

Did the design change? (columns added or removed?)

Are you running the package in 32-bit?

Because enterprise data usually takes more then just a few gigabytes.

And it needs to be available 24/7. If you store it...

You can specify the connection options at the server level.

Right-click on your server in the Object browser and select properties.

Go to Connections and you'll see Implicit Transactions in the list.