Is This Possible?
Posted on 2006-04-25
I currently have a SQL Server DTS Package that imports a fixed formatted text file from my hard drive into a SQL Server table. I execute the DTS package from my vb.net windows application.
This process works fine, but what I would like to do is use the OpenFileDialog class to allow the user to choose which file they would like to import, instead of using the default file name and location as specified in the DTS Package. Is is possible to send the path of the file into the DTS package as a parameter?