The 2 points is just to make your Mondays a bit more bearable...

Probably the last...

Nice article, thanks.

What is the spam? I find it also difficult and hard to understand what Celko is jabbering about 😀

(something about ISO standards? With no link to reference...

sarvade.inder (11/21/2011)

---

Hi Sam,

Could you help me out, by using Script Component how we can achive that.

Can you send me a Link or Code of the process to achive <5000 and...

Why on earth wouldn't you use a conditional split? It is made exactly with that purpose.

You could write a script component that routes the rows to different outputs according to...

The "what's new" page for SSIS in 2008R2: http://msdn.microsoft.com/en-us/library/bb522534.aspx

Only the ADO.NET destination has changed, so I don't really expect problems when upgrading from 2008 to R2 for SSIS.

I like the idea of the question, but it could have been worked out better, as vk-kirov mentioned.

Congrats!

Sean Lange (11/18/2011)

---

I don't think you can increase the pressure...

geetha@in (11/18/2011)

---

Both were successful but in case of SSIS i have received the oracle table name in sql server database with DBO schema but not actual schema belongs...

You can pass variables as parameters to the OLE DB Source SQL query:

http://msdn.microsoft.com/en-us/library/ms141696.aspx

However, this can be somewhat buggy from time to time. Especially if you are using other sources than...

I would compare the values of those two variables in a script task.

http://www.programmersedge.com/?p=1350

You can throw an error there:

http://consultingblogs.emc.com/jamiethomson/archive/2005/11/03/SSIS_3A00_-Throwing-errors-from-script-task_2F00_component.aspx

Make sure the variables are scoped correctly so that the script task can...

If you read the MSDN article referenced in the explanation, you will notice...

Elliot Rapp (11/18/2011)

---

Thanks!

My hope was to set the datatype just before the cube. My initial hope was to use a calculated value in the measure to convert the string...