In the data services designer, I'm importing some tables via an ODBC connection and some flat files. They will go in to new tables in my staging db.
I'll have to do the same jobs for 5 countries. Is it possible to change which source database the job is using? And which destination table they will end up in, considering something like Customers_DE, Customers_NO etc.
Looks like the flat files can use variables in the names, but I will need something similar for the databases/tables.
I did stuff like that with the DTS packages for SQL server, so hopefully it's possible with DS too.