May 7, 2003 at 10:42 am
Is there any way to run DTS package from the client side with parameters.
thanks
May 7, 2003 at 10:46 am
Take a look at dtsrun.exe and it's command-line parameters. Here's the BOL page for the utility:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 7, 2003 at 1:38 pm
Thanks for the reply but how can I pass the input parameter from the client side.
Actually, I have created stored procedure which accept two parameters and returns the result and then I want that result in Excel file.
I know that through DTS I can do all that but how can I pass input parameter from client side. I meant to say from dtsrun.
I know any other way to call please let me know.
Thanks again .
May 7, 2003 at 1:48 pm
If you are on SQL Server 2000, take a look at Global Variables and the Execute SQL Task Object. From the Contents tab:
Data Transformation Services | DTS Package Elements | DTS Tasks | Tasks that Copy and Manage Data | Execute SQL Task
BTW, this is a bit about Global Variables, you'll not want to use this task to output the data. You'll still want to use a data transformation task to get the output to Excel.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Edited by - bkelley on 05/07/2003 1:55:42 PM
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply