November 26, 2007 at 6:32 am
I am trying to migrate DTS packages which contain custom tasks from one server to another. I tried saving them to the new sql server but now when i open or run them i get invalid class string errors.
I think i need to 'register the custom task on the new server' any ideas how to do this, what it means?
Thanks for all help ,
Jules
November 26, 2007 at 11:15 pm
I would bet if you open the DTS package the Connection String is still pointing to the other server. Just a guess.
November 27, 2007 at 6:41 am
November 27, 2007 at 10:24 am
if all you need to do is register the DLL you will want to run REGSVR32.exe
You can open the Run cmd box from the start menu then type in regsvr32
November 27, 2007 at 11:47 am
To register a new custom task in DTS:
Install the package on the server where it will be executing. If there is no 'installation', simply copy the DLL to a folder on the server. I typcally create a folder (e.g. c:\customStuff in which I create subfolders like DTSTasks and UDL [under which are MSSQL, DB2, MSAccess, etc]).
In SEM on the destination server, open a New DTS package. From the Task menu select Register Custom Task. Within the dialog presented, type a Description, browse to the dll and select an icon. Click OK then exit the package without saving.
You should then be able to open the DTS package in question on the server. In order to edit the package from a client machine, you need to repeat the above steps on the client. Remember, when DTSing, everything happens on the system where the editing, executing, etc. occurs.
HTH,
Art
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply