-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Praba
Message 5 in Discussion
Hi,
You can execute the DTS Package from
Stored Procedure using this way, see below for more information.
Create procedure sp_DTS_Load_COSy_Stage --(@InConnection varchar
(255))
as
set nocount on
declare @pkg int, @rc int
--Create an instance of a DTS package
exec @rc = sp_OACreate 'DTS.Package', @pkg output
--Load the baby up
exec @rc = sp_OAMethod @pkg
,'LoadFromSQLServer'
,null
,@Servername = "(local)"
,@Flags = 256 --NT authentication
,@PackageName = "COSy ODS - LOAD TXT TO COSy_STAGE"
--Set any properties of the package
--exec @rc = sp_OASetProperty @pkg
-- ,'GlobalVariables ("TextFileConnection").Value'
-- ,@InConnection
--do it
exec sp_OAMethod @pkg
,'Execute'
--destroy the instance
exec sp_OADestroy @pkg
Go
Thanks,
Praba
-----Original Message-----
From: vijrag
[mailto:[EMAIL PROTECTED]
Sent: Thursday,
November 06, 2003 11:07 AM
To: BDOTNET
Subject: Re: Pls Give me a
SOLUTION - URGENT !!!!!!!!!!!!!
New
Message on BDOTNET
Pls Give me a
SOLUTION - URGENT !!!!!!!!!!!!!
Reply
Reply to Sender Recommend
Message 4 in
Discussion
From: vijrag
HI,
Try executing the DTS package from a Stored
Procedure and call the stored procedure from the asp.
vijrag
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
