To do this in MS SQL Server, add the following to the beginning of your column selection: ROW_NUMBER() OVER( ORDER BY b.Id) as NID which alters the example view to: SELECT ROW_NUMBER() OVER( ORDER ...

Don't let an error message or two stop you from getting what you need. Here's a quick trick to keep things running. When building an SSIS package, you probably find ...