Specifying DTS Data Source at Run-Time

#1

Set up a DTS package to import data into SQL Server from Excel. I would like
an end user to execute the package, even right from Enterprise Manager, and
specify the spreadsheet name and location at run-time. I would also like to
allow them to browse for the spreadsheet, much like an ellipsis button would
do in a standard file selection interface.

What are my options?

Thanks

#2

This is not really what DTS is all about, so you really need to think about
security and such like. Assuming you overcome this, I wrote this task, just
to illustrate how far I could misuse a product!

Open File Dialog Custom Task
(http://www.sqldts.com/default.aspx?226)

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Brett Ossman" <BrettOssman (AT) discussions (DOT) microsoft.com> wrote

Quote:

Set up a DTS package to import data into SQL Server from Excel. I would
like
an end user to execute the package, even right from Enterprise Manager,
and
specify the spreadsheet name and location at run-time. I would also like
to
allow them to browse for the spreadsheet, much like an ellipsis button
would
do in a standard file selection interface.

What are my options?

Thanks

#3

Totally understand your concerns. I needed a quickie, temporary solution.
We will engineer a better solution later.

Thanks

"Darren Green" wrote:

Quote:

This is not really what DTS is all about, so you really need to think about
security and such like. Assuming you overcome this, I wrote this task, just
to illustrate how far I could misuse a product!

Open File Dialog Custom Task
(http://www.sqldts.com/default.aspx?226)

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Brett Ossman" <BrettOssman (AT) discussions (DOT) microsoft.com> wrote in message
news:5D8ADC57-19E4-475C-8348-2C9C0D5D7A8D (AT) microsoft (DOT) com...
Set up a DTS package to import data into SQL Server from Excel. I would
like
an end user to execute the package, even right from Enterprise Manager,
and
specify the spreadsheet name and location at run-time. I would also like
to
allow them to browse for the spreadsheet, much like an ellipsis button
would
do in a standard file selection interface.

What are my options?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Specifying DTS Data Source at Run-Time

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Specifying DTS Data Source at Run-Time - 05-20-2005 , 09:53 AM

Re: Specifying DTS Data Source at Run-Time - 05-20-2005 , 10:26 AM

Re: Specifying DTS Data Source at Run-Time - 05-20-2005 , 01:21 PM