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?)

  • Have you tried building the SQL in an expression and using that as your data source (ie, no parameters)?
    You might have more success if you explicitly name your columns too.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.