0

I have the below script in the Source Editor in a SSIS package and I get an error. I change to a Select * and it works. I'm not sure why this is not working. It works in P/SQL. Any help would be appreciated!

This works in my package:

select * from Test

This does not work in my package (but works in PL/SQL) and I get the below error. 

 select * from (select id, color, shape,
dense_Rank () Over (Partition By id order by id desc as SeqRank)
    ) x

Error: 0xC0202009 at Data Flow Task, OLE DB Source [111]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

BIDeveloper
  • 2,628
  • 4
  • 36
  • 51
Mr John
  • 231
  • 1
  • 3
  • 18

1 Answers1

0

Best approach for this questions is instead of creating a subquery one could create a CTE. A CTE is compatiable with SSIS.

Mr John
  • 231
  • 1
  • 3
  • 18