RE: "duplicate" column names cause excel import fail

Hello adolf,

The error has nothing to do with what is in the spread*** . The error says there is a duplicate column name of "ErrorColumn" in the pipeline. ErrorColumn is a column added to the pipeline when you consume an Error Output from a component.

I would be interested as to how you came by this error. It looks as though you are using the Import/Export wizard.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

I saved the xls as a csv, tried again and it worked.

SSIS has once again proved to be unstable.

"adolf garlic" wrote:

I am getting the following errors when performing a simple import
data wizard using excel as source:

- Validating (Error)
Messages
Error 0xc0047008: Data Flow Task: The package contains two objects
with the
duplicate name of "output column "ErrorColumn" (12)" and "output
column
"ErrorColumn" (37)".
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Source - Sheet1$" (1)"
failed
validation and returned validation status "VS_ISCORRUPT".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed
validation. (SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task
validation. (SQL Server Import and Export Wizard)

The spread*** does *not* have duplicate column names!

These are the columns in the xls
RevenueTypeID,
RevenueValue,
RevenueAssetCode,
SpotRevenueToBaseCurrency,
DealID,
RevenueAssetID,
ErrorCodes,
ErrorColumn
Why am I getting (yet another) "error" with SSIS?

Nothing has the xls open.
I have db rights to create tables etc.
The more I use SSIS the more I hate it.



.