DI Studio: Change source dataset with another datset in an Existing DI Job

suvi107 — Wed, 01 Mar 2017 07:14:41 GMT

Hi,

I am a newbie on DI Studio. Trying to learn by myself.

Right now I am handling an old project where all the source datasets are from Access DB's. These Access DB's are accessed by creating libraries.

Now the problem is as per the new IT standard, we need to mobve those data a more robust dataware house. We are planning to have it on SQL Server.

I have moved all the DB's and tables to SQL Server and they could be accessed through the SAS libraries.

Now I have multple data transformations accessing to the access database and I want to change them to SQL server.

Anyway easy way to change the DI jobs so that it could point to the tables present in new lib.

Let me know anybody need more information.

Regards,

Suvi

Re: DI Studio: Change source dataset with another datset in an Existing DI Job

LinusH — Wed, 01 Mar 2017 07:26:51 GMT

If the data model is the same, I would just start to change the library for each table object, and see how that works out.