loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for SSIS

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Veeren

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

SSIS

SSIS

Online Instructor led Course

Platform: Online Meeting

5,000

No Reviews Yet
1 Interested

About the Course


ETL , DW , SSIS SQL Server 2008,2008R2,2012 Business Intelligence

Topics Covered

SQL Server Integration Services
Introduction to SQL Server Integration Services
• SSIS Architecture Overview
• Development and Administration Tools
• The Import and Export Wizard
Hey what is Business Intelligence Development Studio
Introduction to Data Flow
• Data Flow Overview
• Data Sources
• Data Destinations
• Data Flow Transformations
• Data Viewers
Data Sources
• Excel Source
• Flat File Source
• OLE DB Source
• XML Source
Data Flow Transformations
• Aggregate Transformation
• Audit Transformation
• Character Map Transformation
• Conditional Split Transformation
• Copy Column Transformation
• Derived Column Transformation
• Data Conversion Transformation
• Multicast Transformation
• OLE DB Command Transformation
• Percentage Sampling Transformation
• Row Count Transformation
• Sort Transformation
• Union All Transformation
Advanced Data Flow
• Lookup Transformation
• Merge Transformation
• Merge Join Transformation
• Slowly Changing Dimension Transformation
• Pivot Transformation
• Export Transformation
• Import Transformation
• Unpivot Transformation
Data Flow Destinations
• Data Reader Destination
• Excel Destination
• Flat File Destination
• OLE DB Destination
Introduction to Control Flow
• Control Flow Overview
• Precedence Constraints
• The Execute SQL Task
• The Bulk Insert Task
• The File System Task
• The FTP Task
• The Send Mail Task
• Bulk Insert Task
• Data Flow Task
• Execute DTS 2000 Package Task
• Execute Package Task
• Execute Process Task
• Web Service Task
• XML Task
Advanced Control Flow
• For Loop Container
• For Each Loop Container
• Sequence Container
Variables and Configurations
• Variables Overview
• Variable scope
• SSIS system variables
• Using variables in control flow
• Using variables in data flow
• Using variables to pass information between packages
• Property expressions
• Configuration Overview
• Configuration options
• Configuration discipline
Debugging, Error Handling and Logging
• SSIS debugging overview
• Breakpoints in SSIS
• Control Flow: The On Error event handler
• Data Flow: Error data flow
• Configuring Package Logging
• Built-in log providers
Extending SSIS through Custom Code – Scripting
• Introduction to SSIS scripting
• The SSIS script editor
• The SSIS object model
• Script in Control flow: The Script Task
• Script in Data flow: The Script Component
• Introduction to SSIS component development
SSIS Package Deployment
• Configurations and deployment
• The deployment utility
• Deployment options
• Deployment security
• Executing packages – DTExec and DTExecUI
SSIS Package Management
• The SSIS Service
• Managing packages with DTUtil
• Managing packages with SQL Server Management Studio
• Scheduling packages with SQL Server Agent

Who should attend

Who seek SQL Server Development career

Pre-requisites

Basic SQL Server

What you need to bring

Laptop or Desktop with Mic and Headset"

Key Takeaways

Weekly Materials and Bi framework implementation
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Document

SSIS

There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Veeren Chowdary

BTECH with 8 years experience


I am working in Product based company and I was in core MS BI frame work team for more than 8 years.

If you are looking for MSBI online and class room trainings with expert level course details and MDX,DAX topics with real Data engineering projects and interview tips and certifications please join my courses.
Seats Left-

Students Interested 1

Course Id: 24870