I need to run a DTS package from a stored procedure. I have created a stored procedure that calls xp_cmdshell using dtsrun. I have performed testing from both the stored procedure and from the qu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10219437.html
Hi Experts
I am trying to write a stored procedure that will execute the DTSRUN command. My stored procedure looks like this
CREATE PROCEDURE DBO.EXECUTE_DTSRUN
@Server_Name VAR...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20075335.html
Hi.
in dtsrun utility, there is the parameter /Z it encrypt the whole line
/Z
Indicates that the command line for dtsrun is encrypted using SQL Server 2000 encryption.
does anyone knows h...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20903517.html
Hi.,
how do I create a /Z parameter by sql (for dtsrun)? Is there any sys sp or any other way to doing this..
I know it can do it through dtsrunui.. but i want it in some other way
Regards
D...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21003905.html
How do i pass a variable using the command prompt to my DTS program.
I'm Using
DTSRUN /S "Server" /Uxxxx /Pxxxx /N"Journals"
/A "TrnYear1"="2004"
I set up a global variable in my DTS...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21332111.html
I would like to set up a batch file that executes a DTS that has been created. The .bat file contents:
dtsrun /S FS2/U XXXX/P XXXXX/N MYDTSPACKAGE
When I run this at the command prompt to te...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21483555.html
Forgive me if this is posted twice, I just submitted but it ended w/an error message.
I need to combine these two procedures. #1 needs to run first as it loads the data from a dts package that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21721174.html
I need to determine what DTS packages an SQL Server agent scheduled job is running.
I have a scheduled job that has two steps. The job name matches a DTS package name so that one is a no braine...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21910240.html
On a MS SQL Server database:
I use dtsrun to upload a csv file to a corresponding table, I do this on a daily basis automatically using a vbscript which calls the dtsrun
Lets assume the follo...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20546427.html
Zones:
DatabasesDate Answered: 02/15/2004 Grade: A Views: 0
I am executing a DTSRun statement from a batch file running on Windows XP and am checking for ErrorLevel 1 in order to perform error handling tasks. The DTSRun statement runs without error, yet re...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21470131.html
