We have several AF attributes that are string/GUID/datetime arrays, and want to extract the content using OLEDB. Is that possible?
My memory is a bit vague on that area, but I'm pretty shure there's a problem in PI SQL Commander showing string arrays - but if you use another OLEDB client it works as expected.
I used string arrays in a reporting application a couple of years ago. Pulled them into SQL Server using OLEDB, and then into a Reporting Services report from there. Worked as expected!
I just checked and confirmed this.
PI SQL Commander show an empty value for a string array showing year-information, but if I open the same query in SQL Server Management Tools using OPENQUERY against a linked server I get this result: [2012, 2012, 2006, 2002, 2001, 1999]
Thanks for your answer, Asle. Sounds good .. I'll look into it.
Retrieving data ...