May 4, 2006 at 9:24 pm
help! scheduled job that transforms data from notes fails. The error message is ...
DTSRun: Executing...
DTSRun OnStart: Copy Data from Results to [notes].[dbo].[addbook] Step
DTSRun OnError: Copy Data from Results to [notes].[dbo].[addbook] Step, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Function sequence error
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC Driver Manager] Function sequence error
Error source: Microsoft OLE DB Provider for ODBC Drivers Help file:
Help context: 0
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: ODBC Driver cannot be used because it does not support one or more of the following APIs: SQLTables, SQLColumns, or SQLGetTypeInfo.
Error source: Microsoft OLE DB Provider for ODBC Drivers Help file:
Help context: 0
DT... Process Exit Code 1. The step failed.
Please advise
May 5, 2006 at 7:58 am
Does it work when run from the server where you hav scheduled when run by a user?
May 5, 2006 at 6:55 pm
The package can be executed using the right click menu.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply