OPEN DIALOG IN A DTS PACKAGE?

[PrgrmsAll]

Is it possible to prompt the user to select a (input) file by way of a dialog box, as in VB? I basically want the DTS to run, and prompt the operator to locate an input file (Excel in this case) which will then be imported into a table. All elements work, all I need is to create the prompt, if possible.

Thanks in advance.

 

[SQLDenis]

Only if the user runs the DTS package on his machine


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[PrgrmsAll]

Let's just say they will, in this case.

 

[SQLDenis]

Then you can just put the VB code in an ActiveX task and store the result in a global variable


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/