Hello,

I'm having trouble running a DTS package that pumps data from an Excel sheet
into a table in SQL Server. The package runs well when starting it from
within Enterprise Manager. But every time i change the name (DataSource) of
the Excel file to be imported, the designer asks me to CLEAR the
transformations. Doing so makes the package run again.
Now, my problem is that I want to run the package from VB. I change the the
Datasource property for the Excel file and the SourceObjectName of the
DataPump task.
When running the package the packagelog shows the following error message :
(Step Error Description:The Data Pump Task requires Transformations to be
specified.)

Anybody who can help me with that problem ?

Kalle

In article <ehaL#BYZEHA.3804 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Kalle Fiegl wrote:

Changing the DataSource property and the SourceObjectName property shouldn't
matter so long as the SourceObjectName, in this case a worksheet, contains the
same metadata as the original, that is to say columns of the same name.

Is this the case?



Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yes, this is the case. Right now I'm working with one one single XL file.