Sql 2008 - Data Import Error

Hi Guys,

When I try to import data into Sql 2008 July CTP, I get the following error:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

- Pre-execute (Error)
Messages
* Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\..\Desktop\test.txt" has started.
(SQL Server Import and Export Wizard)
* Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004002.
COM error object information is available. Source: "DTSAdapter.FlatFileSource.2" error code: 0x80004002 Description: "The processing of file "C:\Documents and Settings\..\Desktop\test.txt" has started.
".
(SQL Server Import and Export Wizard)
* Error 0xc0202040: Data Flow Task: Failed to open a fastload rowset for "[DataTest].[dbo].[test]". Check that the object exists in the database.
(SQL Server Import and Export Wizard)
* Error 0xc004701a: Data Flow Task: component "Destination - test" (58) failed the pre-execute phase and returned error code 0xC0202040.
(SQL Server Import and Export Wizard)

- Executing (Success)

- Copying to [Nomura].[dbo].[test] (Stopped)

- Post-execute (Stopped)
Messages
* Information 0x402090dd: Data Flow Task: The processing of file "C:\Documents and Settings\..\Desktop\test.txt" has ended.
(SQL Server Import and Export Wizard)

- Cleanup (Success)
Messages
* Information 0x4004300b: Data Flow Task: "component "Destination - test" (58)" wrote 0 rows.
(SQL Server Import and Export Wizard)

Any Ideas?

Thanks

[2031 byte] By [Kruz] at [2008-3-5]