18 January, 2010

Integration Services - SSIS

I'm going to learn a little of SSIS to migrate an older SQL Server 200 Database to new SQL Express 2008. After research some webs and blogs, I think, in my first overview that it's an intuitive tool to manage the tasks on the our databases.

After install SQL Server 2005/2008 with the Analisys Services, Reporting Services and Integration Services packages, you can create some BI related projects on your Visual Studio. We create a SSIS project and we have a tour inside of the toolbox, features, and the best tool, the designer.

If you are in this step, I strongly recommend to follow a some basic guide, because SSIS seems a really good tools that it can help us.

Recommend site: http://msdn.microsoft.com/en-us/library/ms141026.aspx