You're most likely going to want to try to use an asynchronous transformation script component in mid-stream. Why asynchronous? Because it's 2 rows for every 1, which isn't...

pamozer (4/30/2012)

---

In my ssis package how do I change the database that the procedure is running on in the for each container. I have an Execute SQL Task that...

DataAnalyst110 (5/1/2012)

---

Evil Kraig F (4/30/2012)

---

Until we see the error you're getting this is hard to troubleshoot, however, you might want to take a look at the column and WHERE test...

Greg Edwards-268690 (5/1/2012)

---

Jeff Moden (5/1/2012)

---

Evil Kraig F (4/29/2012)

---

SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of good people, including...

tinnusqlserver (4/30/2012)

---

Thanks Craig for your response. Our goal is to generate a report by using the snapshot table. we are creating a forecast comparison report which will compare the forecasts...

Two things.

1) Create your view as a passthrough query, preferably with the necessary restrictors. That'll help not have to pull the entire table back to access and into memory...

Use a derived column that will check for blank spaces and insert the null version of the datatype into the column if that happens.

Basically, for each column, you'll do something...

Well, no, not really.

You can either reconstruct the data from an auditing structure which will hold all deltas, or you can set up a process (say, that runs overnight) that...

Hey Rich, how's it going? Graduated to partitions since I last saw you, congratz. 🙂

What Gail (and a few of us) really need is a consolidated script that you...

sqldba_newbie (4/30/2012)

---

Minaz Amin (6/11/2009)

---

You need to consider scaling up your processor, RAM, Netwrok Speed, Fast disk subsystem apart from DB load balancing. If number of users increase then start thinking...

Until we see the error you're getting this is hard to troubleshoot, however, you might want to take a look at the column and WHERE test the ISNUMERIC(Academic_Score) = 0...

pamozer (4/30/2012)

---

So we currently have 18 instances across 16 servers with approximately 350 databases per instance. I have to run multiple stored procedures against each database and the combine...

See, a single row, to me anyway, is...

TravisDBA (4/30/2012)

---

This kind of puts people into a quandary because on the one hand the business for whatever reason(s) is not ready for the upgrade, and then on the other...

Safe to assume your Primary Key is also your Clustered index?