June 7, 2002 at 1:23 pm
I'm using DTS in Enterprise Manager in SQL 7.0 to try and transform data from a text file or Excel file to an existing Fox Pro file. However, when I go to execute the package, it fails and I get this error message:
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Query-based insertion or updating of BLOB values is not supported.
Error Help File:
Error Help Context ID:0
I'm not extremely familiar with SQL or DTS, but I've tried all that I can think of to figure this out. I would appreciate any help if someone could lead me in the right direction. If you need more info on the problem, let me know and I will post whatever else is needed.
Thanks,
James
June 7, 2002 at 8:30 pm
Take a look here and see if any help http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=BLOB%2520values%2520is%2520not%2520supported&Queryc=BLOB+values+is+not+supported&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 10, 2002 at 7:50 am
Thanks Antares. I checked out the website, unfortunately with no luck. Nothing I read really answered the error problem I'm encountering. Do you have any other ideas??
Thanks!
June 10, 2002 at 10:38 am
Sorry couldn't help more, cannot find anymore detsail on this. Have you tried to turn logging on in the DTS package itself? May output a bit more detail.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 10, 2002 at 11:41 am
When you say logging, do you mean error logging? If you do, yeah I have that on so it will write the errors to a log file...that's where I got the error part in the original post. Would seeing all of it help more?
June 10, 2002 at 8:02 pm
Yes that is what I meant. Please post the entire contents, maybe I can see something.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 11, 2002 at 2:40 pm
Ok, here is the whole error message:
****************************************************************************************************
DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: (null)
Package Description: (null)
Package ID: {2258FAB0-683B-4AA1-819E-20F4526A72AB}
Package Version: {2258FAB0-683B-4AA1-819E-20F4526A72AB}
Step Name: DTSStep_DTSDataPumpTask_1
Execution Started: 6/11/2002 3:35:06 PM
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Query-based insertion or updating of BLOB values is not supported.
Error Help File:
Error Help Context ID:0
A C C N T |C h e c k i n g / S a v i n g s |39|1009402413|B A N K |0||1000|0|||N |0|N |
||||||||||||||||||||||||||||||||||||||||||||||||||
Execution Completed: 6/11/2002 3:35:06 PM
****************************************************************************************************
June 11, 2002 at 6:28 pm
Sorry I am still not finding anything usefull. Try this. If you can, use a query to define the records to be exported and do SELECT TOP 5 and see what happens. If no error then increase TOP 100, may be a specific record. Also, I believe in DTS there is an option to ignore X number of records. Open the package and right click then choose properties. If you cannot find let me know and I will double check. I am curious if a specific row is the issue? You may also need to check the tables source and destination to see how DTS is defining them. You may be able to alter.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 13, 2002 at 4:55 am
Hi, did you put the blob fields at the end of the select statement?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply