Data Viewer not triggered in SSIS

Question

Using: Windows 7 Enterprise; Visual Studio Pro 2017 (15.3.5); SSDT 15.1

Can't get Data Viewer to pop up on my SSIS package. I did do some Google-fu, and can't find anything relevant (or newer than 2010).

I've used the DV many times in the past, so I'm aware of how to enable a DV, the magnifying glass icon is present on the data flow paths, and I know it's not an issue of a hidden window since my package never actually pauses at any of the DV-enabled points.

Has anyone experienced this before? Am I missing something?

Answer 1

On project property page Change the "TargetServerVersion" so the target server is the same as your database server.

Answer 2

I found this question because I was having this problem also. For me it turns out that the Data Viewer was not popping up simply because there were no rows in the underlying recordset. I had expected it would pop up anyhow and show zero rows, but apparently not.