I want the same package on two servers, test and production, I want to delete some data on a third server, if production server package is running. I...
Hi, I want to retrieve server name(on which package is present) in activeX script of that DTS package. However I don't want to run a sql command on...
The DTS package fires an SP on a remote machine..... We've been facing logging related problems so we will soon be upgrading our sql server...
I am using SQL server 2000 with service pack 1
I have enabled Logging for DTS package in SQL Server, by checking the option Generate Logs in SQL Server in package properties-Logging Tab. When I...
Hi, I am facing logging errors for my DTS packages. I have enabled Logging in SQL server's msdb database. It has table 'sysdtspackagelog' and...
what I feel is 'yes'...linked server will give you the updated data. It should be same as using database2 on ms Access server.
No log was present in sysdtspackagelog table....
Hi, I have a packageA which calls two packages say package1 and package2. There is a on success constraint between package1 and package2 (i.e....
I want to check the average response time of the remote servers I am using in DTS packages, which are scheduled. If this time is more than 100 ms, I...
Thanks, I will set the CommandTimeout property to '0' and re-execute the step if I get the error in future. I have tried and found it working in a...
I am getting following error, when I am executing an ActiveX script(VB) for SQL Server 2000. <br /><br /><br />Error on Line 69<br />) (Microsoft OLE...
The problem seems to occur because of some locking involved for the source table. Suppose there are 11000 records in source table and 9999 of them...
Hi, I am using a DTS package for transferring data from staging tables to warehouse tables. I am using a data driven query task, in which I am using...
Separate names with a comma.
