Creating a DTS package to execute logic

[#1]

Does anyone have detailed instructions on how to create a DTS package (SQL 2000 and 2005) to excute logic?

[Former Member]

Here is the short explanation how you can do it:

-Copy the default logic package

-Add it to you package list via eData - modify package list

-Modify the package via eData - modify package list, right click on the package - edit - click the second button next to the name of the package - choose the advanced button.

-Specify LOGICMODE to 1 and in the LOGICFILE parameters you specify the LGF/LGX file you want to run, so for exampe "LOGICFILE,%appath%\..\adminapp\%APP%\logicfile.lgx"

-Save the package and it should work

-Joost

[Former Member]

Thanks Joost...I'll try it.

[Former Member]

Joost

I've followed your steps, but when I try to save, I get the message:

'This version of DTS package cannot be saved directly to the package.

Please copy a dynamic script and paste to EvDTSModify task script'

I don't know what this means, and how to resolve it. Any ideas?