Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to use table valued function with parameter in ole db source Expand / Collapse
Author
Message
Posted Wednesday, March 24, 2010 5:04 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 10:45 AM
Points: 77, Visits: 274
Hi Everyone,

I have a package where in I have to use a table valued function which accepts parameter from a package variable in OLE DB SOURCE.

NOTE: SQL COMMAND FROM VARIABLE (DATA ACCESS MODE).

I also tried it generating a sql statement including parameter in script task and I tried using it in OLE DB SOURCE but it is giving following error.

ERROR: COMMAND TEXT NOT SET FOR A COMMAND OBJECT.

Please let me know if any one has any solution for this problem.

Thanks in advance.

Post #889416
Posted Wednesday, March 24, 2010 10:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 10:45 AM
Points: 77, Visits: 274
Hi Everyone,

did anyone experienced this type of problem.

Thanks in advance...

Post #889524
Posted Thursday, March 25, 2010 9:11 AM
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
SQL command from Variable should work..What is the Error that you are getting ? Are the SSIS variable data types same as your Function variables ??
Post #889906
Posted Thursday, March 25, 2010 10:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
I just thought of something.

You need to have the command in the variable at design time so just put one in so the designer has something to work with.

CEWII
Post #889996
Posted Friday, March 26, 2010 8:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 10:45 AM
Points: 77, Visits: 274
Hi Elliot and Divyanth,

Thanks for your replies. I will try with your solutions and I'll let you know whether I am able to execute the table valued function or not.

Thanks once again.
Post #890649
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse