Trying to import Excel sheet to SQL Server 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi
I am trying to import a Excel *** into a table in SQL Serever 2005.
The first row of the *** contains the column names, and the columns
match the database table. However, I am getting the following error -
what have I missed??

- Executing (Error)
Messages
Error 0xc02020c5: Data Flow Task: Data conversion failed while
converting column "phy_svc_grp_b" (45) to column "phy_svc_grp_b" (223).
The conversion returned status value 4 and status text "Text was
truncated or one or more characters had no match in the target code
page.".
(SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task: The "output column "phy_svc_grp_b"
(223)" failed because truncation occurred, and the truncation row
disposition on "output column "phy_svc_grp_b" (223)" specifies failure
on truncation. A truncation error occurred on the specified object of
the specified component.
(SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task: The ProcessInput method on component
"Data Conversion 1" (179) failed with error code 0xC020902A. The
identified component returned an error from the ProcessInput method.
The error is specific to the component, but the error is fatal and will
cause the Data Flow task to stop running.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with
error code 0xC020902A.
(SQL Server Import and Export Wizard)

Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data
Flow task buffer failed with error code 0xC0047020.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task: The PrimeOutput method on component
"Source - place_defaults$" (1) returned error code 0xC02020C4. The
component returned a failure code when the pipeline engine called
PrimeOutput(). The meaning of the failure code is defined by the
component, but the error is fatal and the pipeline stopped executing.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited
with error code 0xC0047038.
(SQL Server Import and Export Wizard)

.

Quantcast