Cool, thanks Wayne!

I was able to accomplish it by doing a view upon another view. Thanks for Wayne for the input! 🙂

CREATE VIEW map_people AS

SELECT [CLIENT_NUMBER]

,[CLIENT_SURNAME]

...

Thanks Wayne! I'll be trying it with those ingredients. I was already using MAX GROUP BY and Top 1, but not PARTITION BY

For anyone who may have encountered a similar task, I found a viable solution. Using the script transformation component. The following puts three rows (date, notes, and contact) on one...

I've used XML auto for exporting data from tables and then importing them with a cursor. You think the for xml would work for 6 million records? Maybe you could...

Yeah that should work fine. But I would recommend passing in all the VALUES to be inserted as parameters

(CREATE PROCEDURE usp_insert_loanOfficer (@id int, @branch int, @variable, etc)

If you hard code...

We're in the development stage testing on our local machines. We each have copies of the production databases on our local machines and thats what the packages run against.