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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.