Re: DTS package that uses a table to tell it what to do

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok... I have been looking at http://www.sqldts.com/default.aspx?298 and have
been trying to follow it, but am getting the following error when I try to
run the package,

Step 'DTSStep_DTSActiveScriptTask_BuildMsgBoxString' was not found.

The BuildMsgBoxString is in the package and everything is spelled correctly.
The package runs fine if the SQL Task only returns 1 record, but if there
are more than 1 it fails. What have I done wrong?

Thanks,
Drew

"Helge C. Rutz" <news050424@xxxxxxxxxxxxxx> wrote in message
news:3fecfhF7cuooU1@xxxxxxxxxxxxxxxxx
> Hi Drew
>
> "Drew" wrote
>>I am working on building an app for logging credit card transactions. I
>>made a small excel file that the users edit and the user edits the file
>>and then the file is DTS'd into a SQL Server database.
>> Is it possible to dynamically build a DTS package that reads the
>> Cardholder table to find out what and where to get the files to be
>> imported? The Excel files are stored as follows,
>>
>> SERVER1/Reports/CreditCardLog/*Username*/*username*.xls
>
> that's possible. You have to query the card table to get a list of files
> to import - define the result of the sql task as rowset global variable to
> use later.
> Then you have to loop through an import/transform section where the
> starting ActiveX task changes the file path of the excel connection.
> Take care to set the close connection on completion workflow property for
> the transform, because otherwise you won't be able to change the excel
> file from loop to loop.
> Look here for examples http://www.sqldts.com/default.aspx?246
> http://www.sqldts.com/default.aspx?298
>
> HTH
> Helge
>


.

Relevant Pages

  • Looping and thread completion
    ... - Generate Excel file? ... - Generate RTF file? ... End Loop ... My package is bombing in random places, and I think it's because the ...
    (microsoft.public.sqlserver.dts)
  • Re: Mixed Simulation of Design (VHDL and Verilog)
    ... Dependency exists between package a and package BODY b ... SUBTYPE c_range IS natural RANGE a'RANGE; ... c_loop: ... Segmentation violation if a subtype is used as an index ...
    (comp.lang.vhdl)
  • Re: DTS Import Package
    ... > I would like the ability to run the package multiple times within having ... >> Please note from the above, that I only have one FTP task in my package ... >> I also have one SQL Task and one SQL Task which sends ... >> transformation, I could paste it into the code section. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Import Package
    ... > I would like the ability to run the package multiple times within having ... >> Please note from the above, that I only have one FTP task in my package ... >> I also have one SQL Task and one SQL Task which sends ... >> transformation, I could paste it into the code section. ...
    (microsoft.public.sqlserver.programming)
  • Fun with Tasking
    ... Below is sample code I made representing something I wanted to do with ... this, as I mentioned, "exec" is representative of a family of several ... package Convert is new System.Address_To_Access_Conversions ... end loop; ...
    (comp.lang.ada)