SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Occasional Contributor
Posts: 13

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

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

 

 

Super User
Posts: 5,254

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

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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation