I recently got some vbscript put together and working correctly (because of the help on this forum, thank you), that prompts a user with an inputbox in which they enter a filename, and this filename is used as the datasource in a dts package:
Is there vbscript code that I can use to replace the inputbox, and instead use a dialog box, whereby the user can browse for, and select, the file they want to use as the datasource?
Thank you,
Kevin
Code:
Function Main()
Dim strFileName
strFileName = InputBox("Enter file name without the file extension:")
DTSGlobalVariables("gVarSourceFileName").Value = "C:\Documents and Settings\kskinner\Desktop\NBC\Qwest CDRs\" & strFileName & ".csv"
DTSGlobalVariables("gVarImport_FileValue").Value = strFileName
Main = DTSTaskExecResult_Success
End Function
Is there vbscript code that I can use to replace the inputbox, and instead use a dialog box, whereby the user can browse for, and select, the file they want to use as the datasource?
Thank you,
Kevin