Error loading file to SQL Server 2005

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_FAD_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?
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@.microsoft.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_FAD_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?
>

Error in deleting

When I am trying to delete the record from flat table it gave me following
error and that record doesn't have a constraints / triggers so why it's
giving me this error.
SQL Server Enterprise Manager
Key column information is insufficient or incorrect. Too many rows were
affected by update.
OK Help
Thanks in advance.
you don't have a unique identifier/key
http://sqlservercode.blogspot.com/
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>
|||You need to have a primary key.
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>
|||you need to have a primary key on that table .
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>