SSIS Basics - getting SSIS to move and process data
In this session I will show you how to get started with SSIS, using task and data flow components to transfer data into and out of databases. Loosely based on the articles I have written for Simple Talk attendees will see how to get started with SSIS to solve simple ETL tasks.
LogParser - quicker than SSIS, easier than BCP
This session will introduce people to a free tool from Microsoft that will speed up ad-hoc data import processes and file parsing among other data manipulation uses. LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.
General Information
On arrival please sign in at the reception desk and wait in the foyer to be taken up to the room.
One of the main objectives of the user groups is to introduce new speakers, and here at Cardiff we're always looking for to support anyone who has something interesting to share with the SQL Community. We'll give you all the encouragement and support you need. We're really flexible so if you only want to speak for a shorter amount of time, say 15 mins then this is perfectly fine. If you've been thinking about this, then please get in touch with myself, Steph Locke.