Hello, welcome to SSC.

You've combined three things here at once.

First, that...

No. Passing in and out of the variables set in SSIS is byVal only. You need to use the long name. If you're going to manipulate it...

I'd like to add a special case to the general philosophy here. I worked on a BLOB system that was the majority of storage in the DB, and we...

LinksUp (12/30/2013)

---

First, let me say up front, that 1) I am not a DBA. I am just the application developer and 2) I know this is an open ended question.

Having...

You'll have to go to dynamic SQL to pull this off.

This article will point you at the generic idea:

https://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/

Also, you'll need to name your columns something like Apr13 and Apr12...

Well, thank you. 🙂

On the first issue: 1. There is a very distinct reason for this piece of code and...

blasto_max (12/30/2013)

---

Error at Send Mail: The binary code for the script is not found. Please

open the script in the designer by clicking Edit Script button and

make sure it...

In pieces:

--If Time Clock Details Table doesn't have the number of columns we're expecting, then abort

DECLARE @ColumnCount INT

SET @ColumnCount = (SELECT COUNT(column_name) FROM information_schema.columns WHERE table_name = 'ps_micros_e7_time_clock_details' AND column_name...

SSIS doesn't like dynamic metadata, so you can't really use the basic tools in SSIS for something like that, you'd have to create source/targets for each table.

There are some third...

I highly recommend putting the DB into single user mode, to avoid possible usage overlaps and concerns. You'll want to take the DB basically offline while you do this,...

Karthiart,

If you only have two files like this, I would recommend the above, as it's simpler.

However, if you have multiple XML files missing attribute tags depending on the source, but...

Wasn't justified either way. My apologies, that was undeserved. It didn't read that way to me when I first wrote it.

given...

Apologies, I missed your split response on this earlier. I scrolled too quickly.

I wasn't ignoring anything. Me real point was that indexes could be modified in the future in...

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table -- as might...

Jeff, neat trick with the a.Field > ''. Was unaware of that.

ScottPletcher (12/20/2013)

---

There could be great harm in it if either (1) SQL could have done seeks on both...