Introduction to SSIS by Wise Owl Training - technology in London
Introduction to SSIS by Wise Owl Training - technology in London

Introduction to SSIS

A comprehensive introduction to SSIS

Data Class

Two session course

Beginner

City EC3V

Introduction to SSIS
by Wise Owl Training

Let the teacher know and you will be notified when new dates are added.

You will only receive an email from us if new dates are added for this class, you will not receive any marketing emails, and that's a promise!

Classes

Two session course

Daytime

SQL Server Integration Services (SSIS) lets you automate the import, export and conversion of data. You can use SSIS to fill your data warehouse, import a batch of CSV files or Excel workbooks or just draw beautiful flow diagrams!

Refreshingly, this introductory course doesn't use a large, impenetrable Microsoft database, but instead just uses simple examples to illustrate real-world tasks.

Course details

Course Contents SSIS basics Training topicSolutions and projects Training topicBasic packages Training topicControl and data flow tasks Training topicThe 32-bit question Data flow tasks Training topicConnection managers Training topicSources and destinations Using different data connections Training topicSQL Server (OLEDB) Training topicConnecting to Excel workbooks Training topicNew and existing flat files Training topicMultiple flat files Data viewers Training topicAttaching data viewers Training topicData buffers Basic data transforms Training topicSorting and aggregating Training topicSampling data Training topicDividing and uniting data Data conversion transforms Training topicThe SSIS data types Training topicUnicode and ASCII data Training topicType cast functions Variables and expressions Training topicThe Row Count transform Training topicUser and system variables Training topicExpression tasks Debugging Training topicSetting breakpoints Training topicThe Locals window Derived column transforms Training topicSSIS expressions Training topicUsing SSIS functions Training topicUsing the conditional operator Handling errors Training topicRedirecting and ignoring errors Training topicTruncation errors Conditional split transforms Training topicSplitting data by expression Training topicUsing comparison operators Training topicSyntax for multiple conditions Lookup transforms Training topicRedirecting unmatched rows Training topicChoosing a cache mode Training topicSetting unmatched rows to Unknown Training topicAdding unmatched rows automatically File system tasks Training topicWorking with files Training topicWorking with folders Looping over files Training topicThe file name variable Training topicConfiguring the loop Training topicExpression constraints Importing multiple files Training topicUsing expressions for connections Training topicDynamic connections within loops Covered if time allows If time Looping over rows Training topicObject variables Training topicReading in data Training topicLooping over ADO rows Training topicDynamic connection strings Using parameter placeholders Training topicUsing the ? Symbol Training topicMapping parameters Merge joins Training topicHow they work Training topicComparing two data sets Basic deployment Training topicProject-level deployment Training topicCreating a catalog Training topicDeploying and viewing in SSMS Covered if time allows If time Using parameters Training topicPackage and project parameters Training topicUsing parameters in expressions Training topicDeploying parameters Training topicWhy to avoid environments Why Choose Us? Tick - small class sizesNo more than 6 people per class Tick - proper lunches!Proper restaurant lunch included Tick - testimonials on website535 references viewable online Tick - USB stick includedFree USB stick containing course files Tick - genuine Wise Owl trainersGenuine Wise Owl trainers only Tick - excellent course manualsUnbelievably good courseware View full list of benefits View full list of benefits

Sample customer feedback "Interesting and lots of useful content. Going out to lunch creates relaxed friendly atmosphere. Only course of its kind available for the price. I’ve since been recommending your courses around the office too, so hopefully you’ll see some more HSCIC staff soon enough!" Lewis Cameron (Health and Social Care Information Centre)

"Very good course. Learnt a lot!" Stephen Du Bois (Chartered Society of Physiotherapy)

"Course was very good. Content of database better than normal. Lunch was nice as well." James Van Sluis (NHS North of England Commissioning Support Unit)

"Great course and a great trainer!" Philip Taylor (Health Education England)

"A fantastic course! We will be recommending you to our colleagues." Carl Money (Health and Social Care Information Centre)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You should have a basic knowledge of SQL Server to attend this course (you don't necessarily need to know how to write a SELECT statement, but you should have seen one before). This course uses SQL Server 2016 (although if you're using 2012 or 2014 you'll find it just as useful, as there are virtually no differences between the versions).

Read more +
Obby guarantees good classes

Obby Guarantee

We ensure quality. If your class doesn't reach your expectations, we'll give your money back.

Obby guarantees good classes

Give this class to a friend or loved one

London's favourite classes, courses, and workshops are at your fingertips.

Class location

City
1st floor
40 Gracechurch St
EC3V 0BT
London

Gallery (1)

Introduction to SSIS by Wise Owl Training - technology in London

About your host, Wise Owl Training

Wise Owl Training don't have a mission statement, but like to believe that they are actively doing good. They provide a range of training options and publish all of their materials online so you can decide if you like their teaching style before booking the course. They use only in house trainers and like to keep class sizes small, never more than 8 people and usually 6. Wise Owl Training try to keep classes fun and enjoyable even when teaching software application!

Read more +

Age Requirement

16

Flexible cancellation policy

Any class can be cancelled and fully refunded within 24 hours of purchase. See cancellation policy.

Introduction to SSIS
by Wise Owl Training
Two session course