Hi,
I have a DTS (Data Transformation Serives) that was scheduled to run every morning. But it always got ang error message in its log file:
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
But when I run my DTS manually, it runs succesfully. I checked my ODBC that I used for this DTS is working fine.
I appreciate all your inputs....
Thanks
I have a DTS (Data Transformation Serives) that was scheduled to run every morning. But it always got ang error message in its log file:
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
But when I run my DTS manually, it runs succesfully. I checked my ODBC that I used for this DTS is working fine.
I appreciate all your inputs....
Thanks