SSIS Component Addins

Thanks to John the Greek God again. It seems he has come across another piece of valuable info. It seems you can purchase SSIS development components. Maybe some of these will be useful to you. Also now that you know they can be created, you could possibly generate your own as well to help others. Here is the link:

http://www.cozyroc.com/support/ssis_home.html

If you have any tips, tricks, resources you would like to share with the group please email Susan Fischer at susan@clinchportal.com

Data Warehousing Architecture event in Toronto

For thoses interested in data warehousing architecture or for those who are friends of people who are here is the link to an event in Toronto on December 16, 2008

http://www.tsql.ca/Events/200812DataWarehouseArchitecture/tabid/723/Default.aspx

We look forward to seeing you there. We will be hanging out with Susan Fischer.
She is so supportive of us even though she doesn't understand any of these technologies.

Script to Copy database schema and all objects

Have you every created a database and after finishing it all and putting test data in it, you realize now you need an empty one or need to allow someone else to create one. Well a Greek SQL God just sent me a link to do just that. The link to the article is below:

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Hope this helps you and if you have any tips, tricks, resources that you think may help others in this group please email them to susan@clinchportal.com and I will post them.