Home > Archive > MS SQL Server Tools > March 2006 > Error loading file to SQL Server 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Error loading file to SQL Server 2005
Robin

2006-03-31, 7:34 am

I am trying to load a text file into SQL Server 2005 and I get the following
error messages at the validation stage:

Messages
• Error 0xc00470fe: Data Flow Task: The product level is insufficient for
component "Source - A00U3UNN_Y2006014_FA
D_1_VDF" (1).
(SQL Server Import and Export Wizard)

• Error 0xc00470fe: Data Flow Task: The product level is insufficient for
component "Data Conversion 1" (31).
(SQL Server Import and Export Wizard)


Does anyone know what product level is insufficient?


Andrew J. Kelly

2006-03-31, 9:31 am

Is the compatibility level of the database you are inserting into not at 90?
Are you using DTS or SSIS?

--
Andrew J. Kelly SQL MVP


"Robin" <Robin@discussions.microsoft.com> wrote in message
news:E4E163EE-8A30-418B-8255- 26A2EA155C1C@microso
ft.com...
>I am trying to load a text file into SQL Server 2005 and I get the
>following
> error messages at the validation stage:
>
> Messages
> . Error 0xc00470fe: Data Flow Task: The product level is insufficient for
> component "Source - A00U3UNN_Y2006014_FA
D_1_VDF" (1).
> (SQL Server Import and Export Wizard)
>
> . Error 0xc00470fe: Data Flow Task: The product level is insufficient for
> component "Data Conversion 1" (31).
> (SQL Server Import and Export Wizard)
>
>
> Does anyone know what product level is insufficient?
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com