According to some SQL Server MVP's on Twitter, it is a virtual launch - which...

It might be a long shot, but the lookup transformation is case sensitive.

Try adding upper() around the OrderGroupID column in both tables, so that they are both upper case.

sqlsponge2 (1/24/2012)

---

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...

sqlsponge2 (1/24/2012)

---

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...

So the MERGE statement is not an option, too bad.

Back to the Lookup component. If you run the query that retrieves the records from...

Are you using SQL Server 2005 or 2008?

sqlsponge2 (1/24/2012)

---

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...

So you use a Lookup component to match the rows between staging and MasterHistoryTable.

How did you configure this component?

If you would implement this solution using TSQL only - using left...

OK. How do you match source and target together? Using joins or the Lookup component?

I don't really know Sybase really well, but I suppose there are some sort of management views where you can get all the views in that database? You can use...

Great article Wayne, thanks.

Maybe put the 5 slow ones in one package and the 15 fast ones in another package and then running those two packages simultaneously?

If you create an .udl file on your desktop, can you succeed in creating a connection to the DB2 database?

If you use the MERGE JOIN, you keep the columns of both tables.

Then you can easily test your condition in a conditional split:

(s-code == 1) && (indicator == N)

Don't assign...

How do you check if a record is an insert or an update?

What datatype does the column OrderGroupID have?