Skip to Content
Former Member
Oct 29, 2009 at 11:27 AM

Change database and table names on the fly



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.

Best regards