<2017 October>
SunMonTueWedThuFriSat
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

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.