Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Procedure output

Author  Topic 

jobees
Starting Member

2 Posts

Posted - 2005-11-01 : 04:28:01
Hi,

I hav created a DTS apckage that uses a stored procedure which has an out parameter. But I am unable to gett he value of the output parameter to a global variable. can someone help me accomplish this??

Thanx in advance,
Joby.

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2005-11-02 : 05:32:41
Hi Joby
This is fairly comprehensive:[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_elemtsk2_3e0b.asp[/url]
Are you trying to output a single value or the entire rowset?

Mark
Go to Top of Page

jobees
Starting Member

2 Posts

Posted - 2005-11-02 : 07:07:51
quote:
Originally posted by jobees

Hi,

Hi Marrk,
Just one sentence.
Tx,
Joby.

Go to Top of Page
   

- Advertisement -