About Datawarehouse
Well few words are not sufficient to discuss about features, methodologies of datawarehouse. For people who would like to have defenition of datawarehouse concepts or would like to know whats dimension and Fact Learn Datawarehouse pretty good website discussing about concepts and basics of Datawarehouse :)
SQL Server 2005
In SSIS you might have many times got into a situation where you might have to create a dynamic mapping, Source, Target Let take one by one. If you are planning to have a dynamic source, you could set source value to parameter or store query in parameter and use this parameter for querying table. If you are looking for a solution to have dynamic flat file destination, use expression in Flat file connection. If your requirement is for building from package, task, source and destination follow this link Microsfot Donot think much about version of SQL Server on this page, as you have option to switch for both SQL Server 2005 and SQL Server 2008 Page gives more information on handling SSIS packages. It looks like Microsoft has released GUI versions for SQL Server 2000 Developers and feature rich .Net coding for .Net DevelopersStand by for More information as and when I find out about SSIS 20005
The following are the website I normally use to get solutions for my SSIS issues1. Code Plex webstie for SQL Server Examples
2. Code Project nice website for providing coding references
3. SQL Server Central Website with forum where day to day problems are discussed
4. Database Journal Informative website which dicuss about third party tools available for Database
If you would like to write to me, write to me at rb_talk@live.com
Tool I liked the most with amazing features and most importantly its free is Notepad++, I suggest as a developer to try this tool. Its Cool ;)
