Hi guys, My company recently started using DIS 4.21, but no one has that much experience with it. We had outside help getting what we wanted to do set up, but I am at a novice level with the package. I've got some pictures to illustrate what I'm trying to accomplish. So basically the process we have in place now is to create some datasets, structure them for upload to our server, and then run a transformation to upload the data. Right now, I have to run RTEC1 through the process, wait for it to finish, connect RTEC2 to the process, rinse and repeat. I've read through the documentation for DIS and I know that I want to create an iterative job to cycle through all of the datasets. I created a library (Base) that contains all of the datasets and I used a Library Contents transformation to create a Control Table. Each line of the control table corresponds to each dataset, I then connected the control table to a Loop to run the tables through the job (the job is illustrated in the first picture). This is where I get lost and my luck with the documentation runs out. In my mind, the loop should read the name of the dataset from the control table, load that dataset into the Table Loader, run it through the upload transformation, and go get the next dataset from the control table. Repeat until finished. The problem is that I don't know what settings or conditions I need to make to get the Loop to load the first and subsequent datasets into the job. I've been using SAS for awhile so I am comfortable with coding if that's what needs to be done here, but I have very little experience with DIS. Any help will be greatly appreciated. Thanks!!! Chris
... View more