var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a DTS saved as a structered storage file.How can I provide SQL SERVER Logon ID and password for this DTS package and call it within a SP through the LOGON ID and Password?
exec master..xp_cmdshell 'dtsrun /Ssql1 /NPublish /E'
--This will execute the DTSRun command line utility with the parameters
/S = SQL Server Host Name
/N = DTS Package Name
You can either use /E for "trusted connection" or /U/P to supply username and passwords
You will need the correct permissions to run xp_cmdshell since it is in the MASTER database.