Thanks for the information, I will check it out.

I think I will tinker around with the "replication support only" setting. Thanks for the information.

My current process is as follows:

1.) "Generate Scripts" for each local publication

2.) Day of migration I delete all location publications (Verify they are removed from distributor)

3.) Perform...

The 11 recoreds is my test set. I manually changed 1 record to prove my update process and deleted 10 records to have those to insert. I have...

It appears to be coming in through the OLE DB source as (string [DT_STR]) and comparing in the Lookup to (string [DT_STR]).

That did not work either. Thanks for all your help. I will keep pounding a way. May try a different flow and try and use queries instead...

SELECT *

FROM PurchaseOrders_CA

This is a screenshot of the join I can run in SSMS that shows the record 700 which is in both tables and then the records 701 - 710 are...

Yes, the first screenshot on the left is the data viewer that displays records coming out of the OLD DB Data Source which is the Staging. Then the second...

This project is running SQL 2005.

The lookup simply looks at the OLE DB connection that connects to the History Database and then runs a query to return all rows from the MasterHistoryTable. Then the...

I know if I run queries in SSMS using joins I get the results I am looking for. Not sure how to incorporate that into SSIS. I am...

The lookup function between my ole db data source and the conditional split that returns all the records in my MasterHisoryTable. The ole db is returnin all records from...

I am doing a check for ISNULL to see if the record exists on the target for the inserts and doing a compare on every field for the updates. ...

The jobs are disabled. Since log shipping is no longer used, we are doing cleanup. I just want to verify there will be no negative impact on either...