Suerly it would be easier to create two packages. One which contains
the active script task which loops through the files you want to
import, and then calls the second package which does the import.
To execute the package have a look at previous postings by myself and
Euan Garden on how to do this.
The first package can be used to change the import file of the second
quite easily. An example of this is on my SWYNK site. Note that these
examples are designed for the current Package, but you'll get the idea.
(As this type of issue is cropping up so reguarly now, I will post a
some code samples and explanation on my site early next week.)
SQL/DTS - http://www.swynk.com/friends/green/
> I believe that you have to construct a package dynamically from your
> (VB?) code. You'd be coding around the DTS com object.
> Check out DTSDEMO (on the SQL7 CD) and scriptpkg.vbp (compile it to
> It produces VB source from a stored package.
> Tibor Karaszi
> MCDBA, MCSE, MCSD, MCT, SQL Server MVP
> Cornerstone Sweden AB
> Please reply to the newsgroup only, not by email.
> > I appologise if this is a silly question in advance.....but
> > I have a DTS package and the first thing I do is input the Import
> > (via ActiveX Script). A process then loads the file.
> > Question is is it possible to loop round a Table which contains a
> > file names and trigger the package for each file individually?
> > Thx in advance
> > Nick
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.