sql server dts: importing excel file using SSIS error -- sql server dts

importing excel file using SSIS error

terry
1/20/2006 10:06:32 AM

sql server dts:

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.CManagedComponentWrapperClass.ReinitializeMetaData()
at
Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata()
at
Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object
sender, ConnectionAttributesEventArgs 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

Re: importing excel file using SSIS error

Allan Mitchell
1/21/2006 2:54:32 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

[quoted text, click to view]