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. :)

First Look at DENALI!!!

The good place for testing every software is the client's place, where its implemented in diverse platforms under different projects for various business needs. Some may get what they need from the software and some may not. SQL Server is one among such Microsoft technologies. SQL Server DENALI, the latest of SQL Server would be the most successful RDBMS and Business Intelligence Suite and surely will challenge its own previous versions.


Enhancements in SSMS:


Lets connect to it and start digging.

The CTP 1 version of DENALI is 11.0.1103.9.

The GUI has lot of enhancements and interesting one is the zoom feature for both query and results area. 

You can notice that in the screen shot above. Next is the multiple query sub windows, just like Google chrome tabs.

DENALI is a ocean and cannot be discussed in a single post so this is just a flash of introduction on DENALI. The next post will deal with the enhancements to SSIS Project area.