Tag Info

New answers tagged

0

You mentioned you have 200 source tables and 225 databases. I am assuming the 200 source tables is a count of all tables from all the 225 databases (cause if you had 200 tables in each database that will put your total table count to 45000). You also mentioned that the schema of the database is the same for the 225 databases. You could build the SSIS ...


3

There are a couple of options if you want to use T-SQL and SSIS. You could compare the key columns on the staging table vs ops table to determine if the record already exists and this way you would know if you need to do an insert or update. if using SSIS you can use the lookup component. Your source componenet will have something like 'SELECT keycol ...



Top 50 recent answers are included