VS2005/SQL 2005/.NET 2.0: Editing SSIS packages Visually in VS2005

Posted on 6/30/2006 @ 8:49 PM in #Vanilla .NET by | Feedback | 1387 views

So here is one reason why I feel VS2005/SQL Server 2005/.NET 2.0 rocks.

1. Go to your DB, right click, All Tasks, Export Data.
2. Choose to save the operation as an SSIS package on the file system.
3. Check that into source control.
4. At a later date, edit that in Visual Studio - it looks a bit like below.

 

Now that's ultra cool. Gone are the days when you had to do FOR XML --> OPENXML for data load operations. Truthfully, in most dev. shops I've been in, most DBAs have simply used long ugly INSERT T_SQL statements to import/export their seed data.

The best part, SSIS is fully programmable through .NET code.

Now please tell me thats cool !!! That's BLUDY COOL MAAN !!

More documentation on this - http://media.techtarget.com/digitalguide/images/Misc/sqlserver_ch14.pdf

Sound off but keep it civil:

Older comments..