Script Task - Send an Object to a web service?? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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 2005 Forums

SSIS and Import/Export (2005)

Script Task - Send an Object to a web service??

Author

Topic

koolkeith19
Starting Member

14 Posts

Posted - 2008-12-22 : 14:31:37

Hi There,

I have a stored procedure that resturn a result set. i would like to take that result set and send it up to a web service. I beleive the only way that this is possible is by sending the result set as a type of object... However, I cannot get this to work due to conversions issues.

  Dim VarName As String = ""

        '        Try
        Dim varCurrent As Microsoft.SqlServer.Dts.Runtime.Variable
        VarName = "User::ET_AccountBalance_SEL_ACCOUNT_BALANCE"
        varCurrent = Dts.Variables.Item(VarName)
        AccountBalanceData = DirectCast(varCurrent.Value, HHUploadRoute.AccountBalance)
        AccountBalanceData = CType(varCurrent.Value, AccountBalance)

I would just like to know how to recieve the result set into the object.

Thanks!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources