Can anyone please let me know how to give ODBC connections to work on Remote server. Iam working on Remote server, The job got executed successfully but I couldnot see the result in the target. When I view the target, the following error is being shown,
"ODBC call <SQLDriverConnect> for data source <IMPERIO> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>. Notify Customer Support."
Is there any ODBC connections need to give. Please let me know how to solve this issue.