Users permission to run DTS without being sysadmin Summary:
We would like users to run DTS packages in a production without them ... being sysadmin or owner of the package? ... securitysettings and not a VB, ...
DTS package remotely Summary:
I'm executing a dts package on a remote server from a local machine ... Total Step Execution Time: 379.765 seconds ... Progress count in Step: 0 ...
Slower performance in ActiveXscript task Summary:
I implement an ActiveXscript task in a DTS package for looping several ... store procedures in SQL 2000. ... the processing time increased to 2 hour. ...
Convert interbase to sql server Summary:
Is there a utility for me to convert the interbase database 5.6 ... server 2005? ... but not valid for procedure, trigger, generator convertion. ...
Copying SQL Server Object Tasks Summary:
I am having trouble copying one database from a one SQL Server to and MSDE ... Windows 2003 Server with MSDE 2000. ...
Execute SQL Task Summary:
I want to execute multiple Stored Procedures from a single Execute SQL ... EXEC usp_MySProc2 ?,? ... If i try this in the Properties pane of the Execute SQL task, ...
Too much persisted security Summary:
I've been using DTS for years and, is it possible this has been going ... The default settings for both OLEDB and ODBC connections (for ODBC ... connection to SQLServer) are for "persist security" to be set True. ... the DTS designer to set it back to 1 again. ...
how to set the Variables to a value in a asp script? Summary:
i have created a dts packedge which include a goble Variable. ... the sql task just like 'select * from table where id>?' ... and the goble Variable is named myid. ... how can i set the Variable 'myid' to a value in a asp script? ...
Subqueries in SQL Server Summary:
Is there any similar statement in SQL Server for the below Oracle query ... SELECT ENAME FROM (SELECT ENAME FROM EMP WHERE DEPTNO = 10) ...
Why no row delimiter in fixed text output? Summary:
The row delimiter is not highlighted as an option and sure enough, ... exported data just wraps in a text reader. ...