Using OLEDB provider in Execute SQL task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Using OLEDB provider in Execute SQL task

Using OLEDB provider in Execute SQL task

Rate Topic

Display Mode

Topic Options

Author

Message

vishal.shinde

Posted Monday, February 22, 2010 3:21 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 09, 2012 4:17 AM
Points: 12, Visits: 113

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

Post #870187

Jack Corbett

Posted Monday, February 22, 2010 7:22 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

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

divyanth

Posted Wednesday, February 24, 2010 12:01 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:16 PM
Points: 215, Visits: 551

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 »

Permissions