Building dts/ssis from client system

[Former Member]

Hi All,

Is there any way, we can build a dts/ssis package with custom tasks at client system and place the package to package files under datamanager folder on server, so that we can associate with a data manager package.

Any Help will be greatly appreciated,

kranthi

[Former Member · Accepted solution]

Hi,

look at this Guide this may help you.

There is also a small executable (

%Servername%%Volume$%BPCWebsrvrWebInstallation) to register the Tasks on a client machine (with BI Dev Studio installed) but i don't recommend to build the Package on an other machine than the Server.

On a client machine we had problems to use the debug functionality of SSIS Dev-Studio.

Regards

Jörg

[Former Member]

You can only build the DTS/ SSIS package itself within SQL server enterprise manager (sql2000)/BI development studio (sql2005) on the server itself and copy it underneath the datamanager folder. When the package is added to the package list you can edit the package script from the client side to change the behaviour of the tasks within the package, but you can not add or remove tasks there.

-Joost

[Former Member]

Thank you guys,

Joost - Can we modify the script at client side if using dts or should we go to EvmodifyScript task and change the script there.

[Former Member]

In SSIS you have to use "Modify Script" at client side,

in DTS you have to edit your EvmodifyScript-Task

[Former Member]

Thank you Jorg. Got clear