Forum Replies Created
Viewing 11 posts - 1 through 11 (of 11 total)
-
RE: SQL: Distributed Transaction
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)
Good luck
Dmerm
-
RE: Getting old data using rda
Dear Jeff,
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...
-
RE: DTS and Length of NVARCHAR fields
This will do the trick for you.
-
RE: Determine Location Within DTS Package
Have you tried @@Servername variable?
-
RE: Determine Location Within DTS Package
Why don't you use "(local)" instead of servername? I think it will work for you.
-
RE: If file exists and complete begin process
Hi there,
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...
-
RE: How do I enable DTC for Network Access?
Hi Andrea,
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,...
-
RE: Programmatically change PWD in all connections in all DTS packages
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...
-
RE: Programmatically change PWD in all connections in all DTS packages
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...
-
RE: Globe Code in DTS VBScript
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...
-
RE: Globe Code in DTS VBScript
I don't know any way to use Global functions in a DTS Package
. Instead you can use a Public function within an activeX...
Viewing 11 posts - 1 through 11 (of 11 total)