I have to execute a DTS package from a stored procedure.
THis is my stored procedure:
-------------------------------------------------------
CREATE PROCEDURE dts_staging_to_production AS
EXEC xp_cmdShell 'dtsrun /S[servername] /U[username] /P[password] /N[dts package name]
GO...
How do I remove the trailing semicolon?
My results prints out: general, 3/47:31; 4/11:45;
I need it to print out: general, 3/47:31; 4/11:45
without the semicolon on the end.
Any sugestions?
Thanks I would appreciate any help
I am trying to pass a string to the stored procedure by doing this:
EXEC multipleIndexA @inventory_item_id=' 4935,11105, 4935'
I am not getting any results.
Now here is the code of my stored procedure:
CREATE PROCEDURe multipleIndexA
(@inventory_item_id varchar(500))
as
create table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.