Tear-away, separate windows: SSMS 10000, ADS 0. Yeah sure, I can open up another instance of ADS, but no.

Well, technically you *could* do this with SSIS, but the only ways I can think of involve a lot of hacky things to work around SSIS, like doing it all...

Is there a schema collection in the database? Sounds like there is because you say the XSD is stored in the database.

You need to query the database schema collection, I...

OMG I so agree, was just starting to post something about that! The one killer feature from Access that I wish was in T-SQL. Trying to translate Access crosstab queries...

Yep, as I said, C# has a ternary operator (? : ) that is logically similar to IIF, and VB has IIF, but that doesn't really have much to do...

• This reply was modified 3 years, 9 months ago by  dmbaker.
• This reply was modified 3 years, 9 months ago by  dmbaker. Reason: typos, get rid of accidental emoticon

I don't think I'd blame this on .NET developers...

I'm not certain if this info is pertinent to your question, but thought I would tell you anyway. If this isn't pertinent or you already know about this then please...

You might also want to specify a connection timeout in your connection strings as well, if you start getting timeouts. I've had to do that as well as add the...

Be careful with the output of your stored proc too, especially if  you're outputting character data. I've had problems with VARCHAR columns being exported to Excel, ended up translating them...

I'm not an expert at dimensional modeling by any means, but it seems to me you have a fundamental misunderstanding about how to model this data using the Kimball methodology...

Well, I can get you part of the way, I think.

1. Create a new user variable in the package to hold your Commutations dataset. This variable should have a data...

You can do this with older versions of SQL Server too ( I have to use SQL Server 2008, doesn't support WITH RESULT SETS), but you have to do a...

Is your new server clustered or part of an "availability group"? I think those are the right terms, I'm not an expert on that.

If this is the case, and assuming...

How is that different than not using an ORM?...

By "EF" do you mean "Entity Framework" as in Microsoft? You do...