Is This Possible?

Hey Guys,

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?

Thanks,

Ryan
dchau12Asked:
Who is Participating?
 
JRossi1Commented:

The DTSRun utility has a /A parameter that allows you to set the values of a global variable. This can then be used to set the filename. If the name is
consistent you should be able to do this in code without passing a value.

Take a look at this:  http://www.sqldts.com/default.aspx?292
0
 
dchau12Author Commented:
Thanks for the input.  I will read that article.

I ended up using FileInfo objects to move the file that the user selected through the file dialog box into the directory that my DTS Package is pulling from.  It allows the user to select the file, and then behind the scenes moves the file where I need it withough sending the files directory path into the DTS package.

Thanks for the response though.

Ryan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.