need help with an activeX script in DTS package

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

need help with an activeX script in DTS package

Author

Topic

raritan
Starting Member

39 Posts

Posted - 2007-08-08 : 16:06:55

I have the following code in a package:

With OpenFileDialog
.DialogTitle = "Select Data Source"
.Filter = "All Files|*.*"
.FilterIndex = 4
.MaxFileSize = 1024
.InitDir = "S:\NBC\QWEST\CDRs\"
.ShowOpen
End With

Which gives me the open file dialog box. You'll notice the filter is currently to show all files. How can I change this to show only files that begin with a certain string? What are the available options for the .filter property?

Thanks,
Kevin

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-08-08 : 19:44:20

I'm not sure, but how about this? to list all files which starts with ab

quote:

.Filter = "All Files|ab*.*"

Thanks
Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources