It's a bit more than just streaming into a database. There is some processing, ultimately using a Task Factory Upsert to update/insert. Along the way there are some transformations and,...

Thanks! I'll look into it.

That is very helpful. Thanks!

That's what I thought. Thanks for the sanity check!

I had tried that, but the server wasn't showing up. So I just typed it in and lo and behold, there's the package I'm looking for... Oy, what a dunce.

Thanks!

I added a where clause to filter out 'Work' and a case for ''. Seems to be working just fine.

USE [tempdb]

GO

IF OBJECT_ID(N'dbo.addresses') IS NOT NULL DROP TABLE dbo.addresses;

CREATE TABLE...

Sorry, just saw the posts with questions about the sort order.

We DO want the most recent of a given address type, i.e., the highest AddrID, which is what Lynn's code...

The "Work" option is not to be included in the data. They only want Billing, Mailing, Home, blank (because address type isn't required).