November 26, 2019 at 2:57 pm
I'd like to import the .xel files created by extended events into a table. While I know you can do this with a select statement and I have, I am trying to figure out a way to do it as a data source in SSIS. The select method is slow, and I'd also like to copy the file to another server first, so I figured this would all make more sense in a Data flow task. I tried importing it as xml and excel but I can't get it to work. I'm not sure if it's the delimiters i chose or it's just not possible this way. Anyone have ideas? I've searched the web and so far no luck. Thanks.
November 27, 2019 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 27, 2019 at 6:26 pm
have a look at http://byobi.com/2015/12/3-methods-for-shredding-analysis-services-extended-events/ - one of the methods is a C# one that you can do in SSIS.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply