Hello,

I have a dts package that pulls data from a .csv file and then scrubs and
loads it into a table. Is there a way to change the file path and/or name
using t-sql prior to executing the package?

Any help would be greatly appreciated!
Thanks in advance.

Hi Mark,

"Mark" <Mark (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:4CCDB835-EBA2-44E8-A92B-9B1C0327419A (AT) microsoft (DOT) com...
you can simply use the dynamic properties task inside of the dts package to
change the filepath before importing the data.
You can read it from an ini file or query a database or maybe pass it as
variable to the package.
Depending on usage and invokation of the package one way might be prefered.

Helge

You can use a Dynamic Properties task but you can also use something
like this

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



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

if you load the package and have the package use a global variable as the
path location, you would be able to modify the global variable prior to
calling the DTS Package's Execute() Method.

DTSRUN also has a command line parameter to set Global Variables prior to
the call to Execute().

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com

If you wanted to do this by only using T-Sql, you would have to load the
DTS Package2 object using the _OA methods in a stored procedure and call
the Execute() method on the object. If your package takes longer than 60
seconds to run, you may have to work through some timeout issues. This is
not a very graceful solution, and there are much better ways to yield the
same results.

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com