Asynchronous script transform (google that phrase) to transform the input properly would be my recommendation here. You have a variable set of inputs you want to control for.

The...

dbo.Split is not a built in function. They're referencing building a function to do that, such as the following:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

What you basically do is turn the comma delimited string into...

I gave that game up about 5 years ago, and I was late to the party even then. After a year...

Your website logs in (usually) via a different login than you do. The security for that login needs to be reset on the restored database. What happens is...

KGJ-Dev (7/7/2014)

---

I will be writing a stored procedure in in db1 and i wanted to access the TableA's data of db2. i am aware of using the linked server....

dndaughtery (7/7/2014)

---

I have another connection mgr connecting to this excel file in a file task to rename it just before the connection manager in the dataflow is used. Could it...

First, having to keep your schema intact across all dependant objects and avoiding SELECT * queries is a good thing.

However, there are a few approaches. The line by line...

Crap, you're right Phil. Thank you for the correction. Apologies, OP.

I realize this is an older thread, but since it got woken up from it's cave, what's being asked for here is a GREATEST() function.

There is a thread and some...

I know we're derailing this thread, but I'll respond to your final bit first:

the majority of that work is not firefighing. There are always issues that crop up, you fix,...

Still being in 2008, I'm not sure I can speak directly to Package Parameters.

However, I can speak to configurations in general, which is what it sounds like you're describing.

Personally, the...

Anytime I've worked in the healthcare industry, two things drove our regulation and auditing.

1) Our Legal Department, leading to

2) Our custom code to abide by their requirements.

I've never (in 9...

I agree with Phil. You're trying to normalize data. I'd recommend, for this particular instance, to use SQL. Either with the UNION or with Unpivot.

If you need...

winston Smith (7/3/2014)

---

dan-572483 (7/3/2014)

---

Of course if you're a good DBA, not only will put out the fires, you will put processes in place to prevent fires from occurring, and eventually...

SQLRNNR (6/30/2014)

---

Lynn Pettis (6/29/2014)

---

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are...