Ability to pass in a "sheet" to an excel job?

FAQ

Profile

Ability to pass in a "sheet" to an excel job?

Database Help (Home) -> DTS

Next: if and or question

Author

Message

Stephen Russell

External

Since: Feb 10, 2005
Posts: 4

(Msg. 1) Posted: Sat Feb 12, 2005 9:22 pm
Post subject: Ability to pass in a "sheet" to an excel job?
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I have an excell sheet that is giving me some problems. Can I pass into a
DTS job a specific workbook, this current pricing sheet has 65+ workbooks?

TIA

>> Stay informed about: Ability to pass in a "sheet" to an excel job?

Display posts from previous:

Related Topics:

Problem connecting to database with "." in the n.. - I'm trying to write a DTS to load data from a csv file into a database which has "." in the name. I can set up the connection ok but when I try to set up the transform data task, it keeps saying that the first part of the name needs to be adde...

DTS Transformation Error: "Transaction context in use.. - Hi, today I've had a strange DTS error: In one of my transformations I'd been using several Copy Column transformations + one ActiveX transformation using a lookup function. This lookup function uses a second connection to the same SQL server but to a..

DTS data pump field count "error" - I've just noticed a problem with a DTS package I've designed, and was wondering if anyone else had had a similar problem. Basically, I have a data pump task which takes an Excel .csv file and transfers the data into a SQL table. Each .csv column is..

Convert character data with "-" negative sign to.. - I have character data (money) that I need to convert to numeric data type. When I use the convert or cast functions I receive, " Error converting data type varchar to numeric." error. I found that the character data contains credits with a n...

Capture database error message within "Post Row Trans.. - Hi, I have written an ETL application with SQL Server 2000 DTS that, among other thing, loads sequential files into an ODS database. I have used Data Driven Query component, with Data Pump Phases turned on, and Microsoft Data Link Component to insert...

	Database Help (Home) -> DTS	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum