I'm using SSIS to fill a datawarehouse. Until now I used to truncate the tables and refill them every night. Since this job is taking too long, I don't want to empty the tables anymore but only add new records. To do that, I have a column in a table that contains the LastUsedNumber. This is not a primary key column.
Now that I have the lastusednumber I need to select the new records.
The script will look like this:
SELECT * from table1
WHERE recordnumber > LastUsedNumber
Nothing strange until now.
The problem that I have is that the data source of the select is a table of an AS400 system (DB2) and that the data source of the LastUsedNumber is SQL Server .
Since I want to write a SQL Command as data access mode, how can I use 2 different connection sources in one SSIS Data Flow Source because I can define only one connection manager in the source.
I would appreciate it if someone has a solution for me or an way to get around this.
Vera Van Boxel