I want to add one User written code transformation as node 1 in all the DI jobs under one particular folder in DI Studio jobs. I don't want to touch all the DI jobs for adding one transformation as I have to redeploy all and test all the jobs.   Is there a way to make this approach easy by adding user written code transformation in one place and it should execute it for all the other jobs in same folder?    User written code transformation contains few macro variables. Appreciate if some of you could shed some light on this. ... View more

I'm getting the following error while I run the SAS code which query SQL table. It is worth to inform that the code which I ran contains put function to convert data field to character with yymmd8. Format. Is it OK to apply only the Options options SQLMAPPUTTO=NONE to get rid of this error?   Please be informed that my SAS code contains multiple Proc SQL's in which few, query the SQL table and it contains PUT function. So I've to put only options SQLMAPPUTTO=NONE when it contains PUT function for SQL tables and for other query can I mention options SQLMAPPUTTO=SAS_PUT?     ERROR: Error during in-database processing. ERROR: Error during in-database processing. ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'dbo'. ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The batch could not be analyzed because of compile errors. ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'dbo'. ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The batch could not be analyzed because of compile     ... View more