Specifying DTS Data Source at Run-Time - 05-20-2005 , 09:53 AM
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?
Re: Specifying DTS Data Source at Run-Time - 05-20-2005 , 10:26 AM
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
"Brett Ossman" <BrettOssman (AT) discussions (DOT) microsoft.com> wrote
Re: Specifying DTS Data Source at Run-Time - 05-20-2005 , 01:21 PM
Totally understand your concerns. I needed a quickie, temporary solution.
We will engineer a better solution later.
"Darren Green" wrote: