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]

The easiest and fastest way to create either a DTS or an SSIS package for running logic is to copy one of the existing simple packages that come with the software, such as ICELIM or FXTRANS. Once you copy the package, you will need to modify the name of the logic file requested. In SQL 2005, the name is in the MODIFYSCRIPT section, inside managing the DM packages. In DTS, I think the process is to modify the TASK of the DTS package that has the file name, such as FXTRANS.LGL, just switch it to your new logic file.

Just remember, that these are simple packages and if you require additional steps, those would be added independently of the copied package.

[Former Member]

Petar

Thanks; but I get an error.

I made a copy of the IC Eliminations DTS, using SQL Server Enterprise Manger I changed the logic file reference in the task:

TASK(Execute formulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\Refuse.lgx)

and

TASK(ASSIGN PARAMETERS,...LOGICFILE,%APPPATH%\..\AdminApp\%APP%\Refuse.lgx...

Saved the file.

I then add the package using data manager, but when I click on the file with a magnifying glass icon, I get the message:

An error occurred when adding a new package. This DTS file does not contain the requested Refuse Calculations package. Valid package names in this DTS file are: IC Eliminations, IC Eliminations

I'm starting to get quite annoyed with this problem! Like you said, it should just be a case of copying and changing the logic reference.

Any ideas?

Parminder

[Former Member]

Did you rename your new package using sql server development tool, visual studio?

[Former Member]

Sara

In Enterprise Manager...highlighted Data Transformation Services...right clicked...seleced Open Package...opened the copied xxx.dts file...clicked on the assign Parameters...changed the lgx reference...clicked Disply Pkg...selected Task...changed the lgx reference...saved the file.

Parminder

[Former Member]

The Save As... function in SQL 2000 renames data manager packages including any internal package references to the old name. If you did not use this method to name your new version of the copied package, I'd suggest do that and try the execution again.

[Former Member]

Thanks everyone for your assistance, I have managed to resolve the problem