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.
Azure B2B Big Data Business Intelligence Conferences CTP Database Design Developer Fun facts GUI How-To Hyper-V Interview MCSA MCSE Mobile Reporting NoSQL O365 PASS PD Presentation Programming Publication RLS SAGO SBCS Security SoftwareONE SolidQ SolidQ Journal SP1 SQL Azure SQL Database SQL Database V12 SQL in the City SQL MVP SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQLSaturday SSMS SSRS St Lucia T-SQL T-SQL Tuesday TechEd 2013 Training TTSAC TTSSUG Upgrade VDI VHD Virtual Machines Win10 Windows 2012 Windows 2012 R2 XML
- ► 2013 (24)
- ► 2012 (42)
- ► 2011 (33)
- ▼ September (3)