SQL Server Performance Forum – Threads Archive
Import from DB2 transformations stopped working
SQL Server 2000 DTS package imports data from DB2 into SQL Server 2000 running on Windows NT4 box.<br /><br />Everything used to work fine. However, after an update (I’m not sure which one), the local manual execution of the packages stopped working. This was sorta ok, because we would just use Windows XP boxes to do local manual execution. However, the Windows XP boxes would not allow manipulation of the data pumps connected from DB2 to SQL Server. As a work around we would manipulate everything except adding or subtracting transformations using disconnected edit and use our Dev server to add or subtract transformations. (I don’t believe transformations can be added or subtracted using disconnected edit, or at least I haven’t figured out how to do it.) This was fine as within 6 months (now extended to a year) SQL Server would replace DB2 [<img src=’/community/emoticons/emotion-2.gif’ alt=’![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
I feel the problem may lie with the permissions of the package.
Have you assigned the username & password to that particular DTS package.
Ensure the account used to execute the package has required privileges and same for the SQLAgent account too. If you’r using a local system account for SQLAgent then make sure to change to a local account with required privileges. If the DTS package logging is enabled then better to see the log first by checking where it is failing. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>