Hi,

I'm using a DTS to read an excel file and convert it into
a SQL table. I can do that but I need to pass the name of
the file as a parameter read from a VB screen.

Can anybody help me, please

Thanks in advance

Sonia

How do you call the DTS package ?

Using the object model then have a look at this

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

Using DTSRUN.

If you are using 2000 then look at Global Variables and the /A switch



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sonia Martinez" <anonymous (AT) discussions (DOT) microsoft.com> wrote