Attached below is some sample code that should work, it does not change the
but the select statement, you should be able to change it. It relies on a
as a controller and an activex script task which is on sucess from the pump.
If DTSGlobalVariables("LoopController").Value = False then
Main = DTSTaskExecResult_Success
Private Sub ResetConnection
set oPackage = DTSGlobalVariables.Parent
set oPump = oPackage.Tasks("BuildMini_Task").CustomTask
oPump.SourceSQLStatement = "SELECT City, Region, Country FROM Customers"
> I have a (unknown) list of dBase-Files in a known directory. All these
> files have the same structure and I have to merge all the data in one
> SQL table.
> I succeeded in establishing a loop through all the dbf-files and for
> testing I pop up a message box which displays the actual filename.
> And here is my problem: inside the data pump (no query, just copying)
> I have to set the tablename to the name of the file. How can I set the
> table name via an active script task?
> Thank you in advance
> Horst Gassner
> SkiData AG Austria