Workflow Soluiton

 View Only
  • 1.  SQL Stored Procedure Integration Component Help

    Posted Feb 16, 2011 06:43 PM

    I created a SQL Stored Procedure and add the component to my workflow project however it doesn't seem to be working when its configured.  I noticed that it has a Security tab that the other SQL components in my workfow don't have.  I didn't create the others so I don't know what's different between what I did and them..   Any ideas?



  • 2.  RE: SQL Stored Procedure Integration Component Help

    Posted Feb 17, 2011 12:14 AM

    What kind of connection string did you select when you built the integration?  I always select network library which allows you to specifiy the authentication.



  • 3.  RE: SQL Stored Procedure Integration Component Help

    Posted Feb 17, 2011 09:12 PM

    I'm using the same connection string used for all my SQL components.  I'm not getting any output from the component.  I tested the procedure and it worked fine.



  • 4.  RE: SQL Stored Procedure Integration Component Help

    Posted Feb 18, 2011 07:57 AM

    If your component returns data, you need to ensure that the "Returns Data" checkbox is checked (should be 2nd/3rd page of the wizard)



  • 5.  RE: SQL Stored Procedure Integration Component Help

    Posted Mar 01, 2011 09:02 AM

    I gave up on the stored procedure to do what I wanted and just used directly SQL table integration component to do what I needed.  Thanks for the help though.