I'm using SQL DTS to import data from files with dynamic names into a SQL
table but I'm stuck at STEP 7 of the batch file.(as in the link)

http://www.databasejournal.com/featu...0894_3325731_1

I'm saving my DTS package as a Structured Storage File. I'm able to capture
the dynamic file name is a text file but it seems the DTS run of my package
didn't work because no data is added to my SQL table .
I can't really tell why my DTSRun is not working.
********** following code from M/S **********
Examples
To execute a DTS package saved as a COM-structured storage file, use:
dtsrun /Ffilename /Npackage_name /Mpackage_password
********** *********


So , I've replaced the parameters with these : /FC:\myfilename.dts
/Nmypackage_name /M

Am I correct as I don't use any quotes or spaces or how can I see what is
the DTSRUN error I've got..

Not really looked too much at the article but the intention looks to be the
same as this article

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Jess" <Jess (AT) discussions (DOT) microsoft.com> wrote