@ballardw, @ChrisBrooks, more good suggestions, thanks!
I've reached out to SAS Help to see if there are any sort of reports or modules to assist with this.
Another option came to mind...
MS SQL might have an output that we can make relationship connections with.
Using the first part of the code in the 'macro' of this paper, I've been able to produce a work.dataset with all of the sas datasets in a folder. Being a SAS programming novice, any tips on how to use SAS code to then output/migrate this list of tables to MS SQL Server? I have already made a MS SQL Server connection with DI Studio, so can push out a sas dataset using 'Table Loader' and pointing the table to a library with a MS SQL Server connection.
However, if I'm doing multiple tables in bulk, and not one at a time, I would think I could use the contents of this work.dataset in a User Written Code node in DI Studio and a Datastep or Proc Migrate and _copy_ all the tables to the MS SQL Server library.
Am I right, and this is possible?
Thanks again for all of your help!
-Jeff
... View more