DTS for Excel problem

Hello

I have a problem and need some assistance.
I have a SS that I am loading into a SQL2000 database
I am using DTS for this.
Previously uses used an ADP file to load the spreadsheet.

My problem is that the ADP file uses the ACTIVESHEET for its import.
And the in the DTS you must select the SS you wish to insert.
And the SS name is not standard.

I am trying to use the ADP file and rename the worksheet
any idea how to do this or any idea howelse I can accomplish my goal.

TIA :confused:I will try to help but what does SS and ADP mean? With this explained I can try to help you. :rolleyes:

DePrins
:)|||SS = Excel Spreadsheet within a workbook
ADP = MIcrosoft Access file

I have a spreadsheet with a non specific name
I transfer that file to a shared drive and need to rename the ActiveSheet there. Using access or SQL Server|||Thanks, i will look into it.
:)

DTS deployment issues

Hello!

I'm trying to deploy an application that runs DTS packages from the local machine.

I've read some articles that it would be enough to install the SQL Client Tools on the local machine to make the DTS work . I did this, the package executes a few steps (it shows message boxes and writes data into the database), then (before executing some validation tasks on the data) it throws an exception 'Execution was canceled by user'. I've set the pbCancel flag and the package runs fine on some computers, but on an empty system that only contains my application and the Sql Client Tools I get this exception.

Do I have to install anything else or do I have to make some changes to DTS package to make it work?

Thank you in advance!

this is the wrong forum; Unless your are using SSIS (SQL SERVER 2005).|||sorry, my mistake