TTSSUG Event Review: Lifecycle of an SSIS package

The Trinidad and Tobago SQL Server User Group (TTSSUG) held its second meeting at the Leon Agostini Conference Room, in the Chamber of Commerce Building on August 25th. The meeting had a total of 41 attendees which included members and a few newcomers from various organisations.

We began with a small presentation to explain the mission and goals of TTSSUG and also to introduce the steering committee to the attendees. The presentation ended with an introduction of the main presenter, Gregory Chee. Gregory is an Application Consultant in Microsoft Business solutions department with Esprit Consultants Limited and has over 7 years of IT experience. His presentation, Lifecycle of an SSIS package: From development to production, gave a brief introduction to SSIS and helped people to understand the basic concepts of SSIS. Most of his session was focused on demonstrating how to create and deploy two SSIS packages. The first package was a basic ETL package which introduced Control Flow items such as Data Flow Task and Execute SQL Task. The package also showed the use of Data Flow sources, destinations and some basic transformations. The second package was create to combine data from multiple excel files and compare them to a database in order to produce a report. This package highlighted variables, looping, table lookup, output redirection and package logging. The presentation and the packages can be downloaded here.

I would like to thank Microsoft Trinidad and Tobago team for sponsoring this event and for assisting us with everything that contributed to the event. Also special thanks to Gregory Chee for coming to share his knowledge with the group during his vacation time. Last but most importantly, I would like to thank the people who attended the event and who were interested in attending the event. For more information about SSIS please visit SSIS homepage on MSDN.

0 comments:

Community Links