Viewing 11 posts - 1 through 11 (of 11 total)
1) Make sure MSDTC is up and running
2) Make sure that journaling option is set on the DB2 table (ask the administrators of the AS/400 to do it)
April 19, 2007 at 11:24 pm
Thanks for your reply but as simple as it may sound this problem IS happening and, believe me, I DO select the data from the correct table(s). The...
January 13, 2007 at 2:38 am
May 4, 2006 at 1:28 am
Have you tried @@Servername variable?
April 8, 2004 at 12:35 am
Why don't you use "(local)" instead of servername? I think it will work for you.
April 6, 2004 at 11:28 pm
If you are using SQL Server 2000, you can include in your DTS package the FTP task, do the import procedure, then add a precedence to the next task...
March 3, 2004 at 12:30 am
I don't know if this is going to help you but once i had the same problem between two linked servers i was using. I was trying to insert,...
March 3, 2004 at 12:17 am
I agry with you. Having global DTS variables is the best solution. Reading the registry sometimes might fail because of inadequate security permissions. Reading from ini files might have the...
February 27, 2004 at 12:15 am
The easiest way to do that is ti save the DTS in VB code and see how you can manipulate the connection object through VB. More or less in the...
February 25, 2004 at 11:22 pm
Functions are treated as in VB. You can have as many function as you like within an ActiveX script BUT you cannot use ANY of them in another ActiveX script inside...
February 24, 2004 at 5:27 am
I don't know any way to use Global functions in a DTS Package . Instead you can use a Public function within an activeX...
February 24, 2004 at 12:16 am