Many of them are not aware of MS Datawarehousing(DWH) tools and technique. How is the market for Microsoft DWH in general? are there a demand and need of skilled personals in these areas?
Thanks,
Rajiv.
It is a fast growing market.
Have a look here for information about market shares for OLAP: http://www.olapreport.com/market.htm
These figures say nothing about SSIS, SSRS and they are from 2005.
HTH
Thomas Ivarsson
I want to know how is data stream transfered when i transfer data from one server to other server using client machine (client tools).
When i execute DTS package, is data streamed through client machine to destination as in SQL 2000.
I know in SQL 2000 to run DTS package on server side without streaming from client machine was to run DTS package as sql agent job on server.
Please confirm if this has changed in SQL 2005.
All other tools like AbInitio ETL tool executes on server side.
We were evaluation SQL 2005 for our future projects.
Please confirm.
The package executes on the machine from which it is called.
-Jamie
