I would like your help to two questions:
1 - I am running a query in Oracle through Linked Server SQL Server, when I run the query I am getting the error below to column that has the case:
Msg 7347, Level 16, State 1, Line 2
OLE DB provider 'OraOLEDB.Oracle' for linked server 'LNK-SERVER01' returned data that does not match expected data length for column '[OraOLEDB.Oracle].CASE'PR
RIT'. The (maximum) expected data length is 64, while the returned data length is 6.
2 - I need to schedule a job in SQL Server to bring the previous day's (D-1), but do not know how to do this automatically.
I'm putting the query attached
I appreciate the help