My database is too large. Restoring headers takes far too long for this operation. I need it to be quick. The code above completes in less than a minute.

I down voted everything on that post.  None of the people involved including the original poster, the two people that posted the answers, the idiot that edited the original...

Can you please post the DDL for the tables and the sample data? IE, table creates and inserts for the sample data.

It's mighty hard to read the images you've inserted...

I don't have a Stack Overflow account, let alone a 50 rep on the site. Since the topic is still open, maybe could someone able to post to the site...

Annnnnddddd...

Because I just realized y'all are going to ask.

https://stackoverflow.com/questions/35951765/the-metadata-could-not-be-determined-because-every-code-path-results-in-an-error

Yesterday night, a job failed with a weird error I'd never seen before. I hop onto Google this morning to search for it and find all sorts of interesting responses....

Does she have a business case for changing the data sources? Or did she just do it because that's what she knows?

You *can* connect using the legacy Integration Services connection in SSMS, but only for packages that are deployed to MSDB. I rarely see packages deployed to MSDB in 2012...

From what I understand of the CISSP, the exam is a "lawyers" exam more than it is a "tech person's" exam. That's what makes it so difficult for a lot...

Best of luck with that test, Brandie.  I haven't done it, but I know 2 people who have. One passed and the other missed it be 1 question on...

• This reply was modified 6 years, 8 months ago by Brandie Tarvin. Reason: I can't spell "exams" today

I don't actually feel insulted. It was the way the response was worded with the whole "none of your business" and "you're wrong" comments that made me think the OP...

I'm sorry you see my response as insulting. It was not intended that way. I was trying to assist you in understanding what a landmine you are sitting on and...

Starting in SQL Server 2012, you no longer connect to Integration Services directly like you would in prior versions. It is now accessible as a node in the connection...

You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's screen....

Because I'm studying for my CISSP, I had to put my 2 cents in on this subject.