How to create SSIS package in DENALI???

This may sound funny to all the experts working on SQL Server Integration Services from 2005 till 2008 R2, but the Visual Studio enhancements for the Integration Services Project made me to write this post. You will find few screen shots of those, how they vary from the previous versions of SSIS versions.

This is a look of the control flow in a brand new package of DENALI. Thought of creating a Flush and Load package, so lets drag the all new Data Flow Task into the designer. Check where you find it in the SSIS Tool box, all tasks nicely grouped up.

We are using a Source Assistant to configure the source. Once we drag the Source Assistant into the designer, a popup asking for the type of source rises, exactly shown in the below screen shot.

If you have a connection already saved, then make use of it else need to create a new one just like how we do in previous versions of SSIS. Once the connection (here in example it is SQL Server) is set, need to configure the table as in below screen shot.

I used a sort transformation to order the rows as per the employees salary, for which there is no much change in the setup. Now its the time to set the destination, so make use of Destination Assistant to configure it just like Source Assistant. The below screen shot is of 130% zoomed of the completed DFT. Notice the zoom feature available just beside the annotations.

Moving to Control Flow now, thought of flushing the data every time I want to load the data, so dear EST is called up and configured. Check the screen shots below.

The package is now ready to get execute, so lets fire it!!! Here is how it looks at the execution time.

The output of another package which creates timestamp based backup of specific list of databases is below.

There are lot of things to explore, and one need to find time from the multiple roles of multiple projects. Hope I find it regularly. The next post would be discussing the enhancements and benefits with other transformations. HAND. :)