MS SQL Server DTS - importing excel file using SSIS error

Author

importing excel file using SSIS error

terry

2006-01-20, 1:23 pm

Hi -

I'm pretty new to dts, but I've been able to import a few files so far.
I tried to change the data access mode to "Table name or view name
variable" (I'm importing an excel file), and then I provide the
variable name that has the filename in it.

I get this error:
====================
===============

Error at Data Flow Task [Excel Source [1]]: A destination table name
has not been provided.

(Microsoft Visual Studio)

====================
===============

Exception from HRESULT: 0xC0202042
(Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Pipeline.Wrapper. CManagedComponentWra
pperClass. ReinitializeMetaData
()
at
Microsoft. DataTransformationSe
rvices.DataFlowUI.DataFlowComponentUI. ReinitializeMetadata
()
at
Microsoft. DataTransformationSe
rvices.DataFlowUI.DataFlowAdapterUI. connectionPage_SaveC
onnectionAttributes(
Object
sender, ConnectionAttributes
EventArgs args)

I have no idea where I'm supposed to put a destination table. I've
tried googling the error, but haven't found much.

Thanks for your help!
Terry

Allan Mitchell

2006-01-21, 7:23 am

Hello Terry,

You are not using DTS you are using SSIS, a very different animal.

The filename is not the name of the table or view. The filename would be
the ExcelFilePath property of the Excel Connection Manager. The name of
the table will be the OpenRowset property of the Excel Source Adapter and
will look something like Sheet1$

Allan

> Hi -
>
> I'm pretty new to dts, but I've been able to import a few files so
> far. I tried to change the data access mode to "Table name or view
> name variable" (I'm importing an excel file), and then I provide the
> variable name that has the filename in it.
>
> I get this error:
> ====================
===============
> Error at Data Flow Task [Excel Source [1]]: A destination table name
> has not been provided.
>
> (Microsoft Visual Studio)
>
> ====================
===============
>
> Exception from HRESULT: 0xC0202042
> (Microsoft.SqlServer.DTSPipelineWrap)
> ------------------------------
> Program Location:
> at
> Microsoft.SqlServer.Dts.Pipeline.Wrapper. CManagedComponentWra
pperClass
> . ReinitializeMetaData
()
> at
> Microsoft. DataTransformationSe
rvices.DataFlowUI.DataFlowComponentUI.Re
> initializeMetadata()

> at
> Microsoft. DataTransformationSe
rvices.DataFlowUI.DataFlowAdapterUI.conn
> ectionPage_SaveConne
ctionAttributes(Obje
ct
> sender, ConnectionAttributes
EventArgs args)
>
> I have no idea where I'm supposed to put a destination table. I've
> tried googling the error, but haven't found much.
>
> Thanks for your help!
> Terry

Sponsored Links