Hi
Hope this is the correct forum as I did not want to cross post.

My scenario
 - A VB.Net UI that the user can browse to a csv (already coded)
 - Missing bit (see below)
 - I have a DTS package setup that takes a filename (text.csv) and creates a temp table in tempdB within SQL Server.

Missing Bit
What I want to do in vb is pass the csv filename as a string to the DTS package and run it with the new csv file.

If anyone could point me to any links or give some pointers, i'd be grateful.

Regards
Dan

Hey,

Are you running using the DTSRUN utility, or the SQL Server DTS library? You could use a parameter in a package that takes the name of the file. This parameter is what is used to retrieve the data from. Use a dynamic task to change the name of the package at package runtime.

Thanks,

Brian