Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLBase to SQL via DTS

Status
Not open for further replies.

MIChad76

MIS
Dec 13, 2005
72
US
I am attempting to use a MSSQL DTS to migrate data to SQL for a datamart. When I execute the job from within the SQL DTS Designer all is well but when I try to schedule the job I get this:

Error string: [Gupta][ODBC DRIVER][SQLBASE]00401 DBA COD CANNOT OPEN DATABASE ERROR SOURCE: MICROSOFT OLE DB PROVIDER FOR ODBC DRIVERS

ODBC 8.05.00.13472

---
Chad Smith
michad76@gmail.com

MCP - Microsoft SQL Server
Crystal Reports Certified Professional
GoldMine Certified Professional
Microsoft CRM Certified Professional
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top