Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-08-29 : 15:03:51
|
| Back again,I have a web app (ASP) that uses SQL server 7 for the database. I created a DTS package to export the data into Access for downloading.The users will be able to upload access db's with queries/reports they have written, and allow the other users to download them. 1. Without knowing the name of the access database i am writing the DTS package for, can I pass the name of the Access Database (with Path) to the DTS Package.2. Would it be better performance wise to run the DTS package from a stored proc ( i read com objects are good, but I wish to avoid them) 3. If i got away from the event driven method and set up a Schedule for the DTS to run, could I somehow, call DTS with Each Access DB that is uploaded on the server (I will be storing info for each db in a table in the Sql server. I know this is a tall order, but the BOL,etc help are cryptic to me on this.thanks Much._________________________I am 8 Beers short of a case. |
|
|
|
|
|
DTS SQL S->Access