Hello all,

I would like to use the "Open File" dialog box from within the DTS
package to select the source text file to import. But it doesn't look
like the "GetOpenFilename" method is available to me in SQL Server's
VB script.

Is there another way to use the "Open File" dialog box from VB script?
Is there a way I can get the VB script in SQL Server to reference a
library that has the "GetOpenFilename" method in it?

Thanks for any help anyone can provide,

Conan Kelly

Whilst I cannot help with the method itself it is my opinion that using
DTS in this way is not the way it was intended. I do not see DTS as an
interactive application like this. If I was doing this type of thing I
would have an app that did the choosing of the text file before it
called my package. One of the reasons for this is that what is you have
a transaction running over the package and your dialog box comes up in
mid flow. Maybe you also decided to go get a coffee at the same time.
You will be locking people in the database whilst this happens.

Just my thoughts


Allan


"Conan Kelly" <CTBarbarin at msn dot com> wrote

It is a bad idea for reason that Allan mentioned, but saying that I took the
API and wrapped it in a custom task, because I could! Be careful.

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


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Conan Kelly" <CTBarbarin at msn dot com> wrote