Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Using OLEDB provider in Execute SQL task Expand / Collapse
Posted Monday, February 22, 2010 3:21 AM


Group: General Forum Members
Last Login: Friday, March 9, 2012 4:17 AM
Points: 12, Visits: 113
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?

Post #870187
Posted Monday, February 22, 2010 7:22 AM



Group: General Forum Members
Last Login: 2 days ago @ 7:36 AM
Points: 10,808, Visits: 14,832
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #870335
Posted Wednesday, February 24, 2010 12:01 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 17, 2013 4:51 PM
Points: 215, Visits: 556
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...
Post #872154
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse