Data Transformation Services Import/Export Wizard

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Data Transformation Services Import/Export Wizard

Author

Topic

ani
Starting Member

3 Posts

Posted - 2005-08-25 : 05:18:11

When I use the SQL

and attempt to copy data from a table having varchar to a temporary DBF file that I have created that includes a memo field, I get the following error message: Query-based insertion or updating of BLOB values is not supported This prevents me from being able to export any data in SQL Server that exceeds 254 characters (the maximum allowable length for a character field in a DBF file.sengupta.anindya@gmail.com

- Ani

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-08-25 : 11:26:42

Here's what I would do.

1) Import all but the memo field.
2) Export the PK column and the memo field to a text file.
3) Import the text file into the DBF.
4) Update the memo column using the PK.

I'm not sure if you'd be able to do that because I don't know everything about your system but it sounds a lot easier then attempting to figure out the solution to your problem.

Daniel
SQL Server DBA
www.dallasteam.com