And if you put the staging tables in a database you have a ...?

http://www.amazon.com/Data-Mining-Microsoft-Server-2008/dp/0470277742/ref=sr_1_1?ie=UTF8&qid=1333604114&sr=8-1

Yes, it can be done in SQL.

Check out "dynamic SQL" on Google.

SSIS: Custom Logging Using Event Handlers

+1 for the licensing

How to get your cube to the other server:

Analysis Services Deployment Methods

(this was the first result for the google search deploy ssas)

Or just deploy from the BIDS...

EXEC sp_MSForEachTable 'SELECT X FROM ?'

This will only work if the column X is in all the tables of the current database.

Great question, thanks. I never use this datatype though.

Glad you found the issue, and thanks for posting back!

SQL_Surfer (4/4/2012)

---

PATINDEX is not going to work. And temp table solution is also not going to work. Since, those values are (list of strings) are in table and can contain...

Thanks for posting back the solution.

Does the error persist if you drop and recreate the task?

+1

I have my beta exam of developing sql 2012 data warehouses this week, and MDS is on the skills list. So...

Nope! It existed since SQL 2008 (R2?). Everybody just ignored it 😀

Surprised this QotD didn't hit 100% correct answer, with the...

Evil Kraig F (4/3/2012)

---

NuNn DaddY (4/3/2012)

---

Is there anyway I could "point" my local copy of BIDS to the SQL Server that has Integration Services installed on it so I no...

Since these extra values are only inserted for the first occurence of a new value in the first column, you'll need a script component. In the script, you'll keep track...