April 23, 2007 at 12:09 pm
I am importing a table from a text file, but need to add a sequence in the first column that does not currently exist. Is there a way to insert a sequence into the DTS wizard while I am importing the other data?
Thanks
April 23, 2007 at 1:46 pm
Do you mean to add a sequence number in the table?
April 23, 2007 at 1:52 pm
Yeah. I have built the table in sql server and I am trying to import a txt file into it in dts. I have three columns the first an int, but I do not have anything in the txt file to load into the table. I end up getting this error:
Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
(SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task: There was an error with input column "Sort_order" (55) on input "Destination Input" (32). The column status returned was: "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task: The "input "Destination Input" (32)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (32)" specifies failure on error. An error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
April 23, 2007 at 2:03 pm
Yeah. I have built the table in sql server and I am trying to import a txt file into it in dts. I have three columns the first an int, but I do not have anything in the txt file to load into the table. I end up getting this error:
Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
(SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task: There was an error with input column "Sort_order" (55) on input "Destination Input" (32). The column status returned was: "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task: The "input "Destination Input" (32)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (32)" specifies failure on error. An error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
April 23, 2007 at 2:55 pm
Mike,
Rebuild the table with the first column being an integer IDENTITY (1,1) NOT NULL. Then, run the import/export wizard again and make sure the three fields in the input file are mapped to the 2nd, 3rd, and 4th columns in the table.
Greg
Greg
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply