Home Forums Data Warehousing Integration Services Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?) RE: Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?)

  • Luis Cazares - Thursday, March 8, 2018 9:35 AM

    Have you tried making it an inline table-valued function?
    I don't get why would you need a linked server to make it a view or how can you send parameters to a CTE inside a view. The problem might be on how you're calling this, but I have no idea of what you're doing.

    I'd rather wrap it in a parameterized stored proc before creating a function...