<2017 April>
SunMonTueWedThuFriSat
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

On this page...

Search

Links

Member of...


ASP Insiders

MVP Visual Developer ASP/ASP.NET

Enter CodeZone

Blog Categories

Microsoft

Blogroll

Deutsche Resourcen

Management

Sign In
 

#  Friday, 13 March 2009

Importing table data is an easy enough task in SQL Server 2005 - but this week we stumbled across this error message:

Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Expected the TEXT token in data stream for bulk copy of text or image data.".
 (SQL Server Import and Export Wizard)

Funny thing is, there were only nvarchar(max) columns on the table, and no binary columns whatsoever. A bit of searching and more staring at the table definition finally pointed out us in the right direction - the target table has a computed field in it, like so:

[MyComputedColumn] AS
 (
  [dbo].[MyFunction](OtherColumnAsParameter)
 ),

Although we had told SSIS to <ignore> it, this error came up. The only work around for SSIS: remove the computed field before doing the import.

References:

http://www.eggheadcafe.com/conversation.aspx?messageid=30015415&threadid=30015404
http://sqlug.be/forums/thread/821.aspx

Categories: SQL Server
Friday, 13 March 2009 11:47:18 (W. Europe Standard Time, UTC+01:00)  #    Comments [1]

 



© Copyright 2017 Christoph Wille

newtelligence dasBlog 2.3.9074.18820
Subscribe to this weblog's RSS feed with SharpReader, Radio Userland, NewsGator or any other aggregator listening on port 5335 by clicking this button.   RSS 2.0|Atom 1.0  Send mail to the author(s)

 
Don't contact us via this (fleischfalle@alphasierrapapa.com) email address.