Using OLEDB provider in Execute SQL task

• vishal.shinde

  Mr or Mrs. 500

  Points: 538

  More actions

  February 22, 2010 at 3:21 am

  #139031

  Hello,

  I want to use OLEDB provide in execute sql task. (Reason why not ADO.NET is that I am not able to set connection string property from a front end which is calling the package). I have requirement of calling a SP which returns a VARCHAR Output parameter.

  I set,

  ConnectionType - OLE DB

  Connection - (1 new OLE DB Connection by choosing new connection)

  SQL Source Type - Direct Input

  SQL Statement - EXEC ? = dbo.USPValidateReferencePorts ? 0

  In the parameter mapping tab I have added 1 output parameter mapped to one of the decalred variable.

  Parameter Name - 0

  Parameter size - 255

  Direction - Output

  Data Type - VARCHAR

  Can you please assist ASAP?

  Thanks

  Vishal

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 22, 2010 at 7:22 am

  #1122935

  What is the problem you are having? You do not provide an error message or a question really so I don't know what to help with.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• divyanth

  SSCarpal Tunnel

  Points: 4303

  More actions

  February 24, 2010 at 12:01 pm

  #1124470

  By looking at your post all i can think of is that your getting an error while parameters to the Execute SQL Task bcz you are using "?" parameters before an = sign.. which is not allowed (as per my knowledge)...

  The best approach would be to use expressions and replace your execute SQL statement with a variable which will hold your expression....

  This is what i have figured out.. dont exactly know what your question is.... AS Jack said Post more information without which nobody can guide you in the right way...