Learnng resources
Keywords
- Big data, Bigdata, Big-data, MongoDB, Mongo DB
- NoSql, No sql, No-sql
- Training, Train, Learning programming, learn,
- Programming languages
Relational DB / Big Data / OLAP
Category Archives: SSIS
Wise Owl: Microsoft computer training videos
At the following link you will find Video Tutorials of:
1. C#
2. SQL
3. SSIS
4. SSRS
http://www.wiseowl.co.uk/videos/
Create and Map a Server Environment
How to automate cube processing with XMLA OR AMO
http://aniruddhathengadi.blogspot.co.il/2011/12/how-to-automate-cube-processing.html
BI SSRS / SSMS / SSAS / SSMS
BI SSRS / SSMS / SSAS / SSMS
Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
Bulk Copy Program – BCP SQL
Bulk Copy Program – BCP SQL
Bulk Copy Program (BCP) – command-line tool used to import or export data against a Microsoft SQL Server or Sybase database. The tool is often more efficient than more recent GUI-based applications, such as DTS, to import and extract data.
Resources: http://en.wikipedia.org/wiki/Bulk_Copy_Program http://databases.about.com/od/sqlserver/a/bcp.htm http://sqlfool.com/2008/12/bcp-basics/
Learn SSIS in 19 video lessons
01 - Getting Started 02 - Performing Basic Tasks 03 - Basic Transformations 04 - Variables 05 - Data Types and Data Conversion 06 - Expressions 07 - Conditional split and derived column transforms 08 - Debugging 09 - Lookup Transforms 10 - Sequence Containers and FOR Loops 11 - Looping Over Files 12 - Other Foreach Loops 13 - Script Tasks using C# 14 - Script Tasks using Visual Basic 15 - Script Components 16 - Expression and Other Constraints 17 - Event-handling and logging 18 - Error handling 19 - Parameters and deployment
Step by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure
http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
How to load a variable from “Execute Sql Task” in SSIS package
How to load a variable from “Execute Sql Task” in SSIS package
http://stackoverflow.com/questions/15406424/how-to-load-a-variable-from-execute-sql-task-in-ssis-package
WiseOwlTutorials – Youtube homepage
-
What to watch next
-
Excel VBA Introduction
Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don’t need any prior programming knowledge as we’ll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort! -
SQL Server Queries
The videos in this list form a complete tutorial in writing queries in Microsoft SQL Server. -
SQL Server Reporting Services (SSRS) Tutorial
This set of videos teaches you how to create reports in Microsoft SQL Server Reporting Services. Starting with the basics of creating a new report project these videos will lead you all the way through to creating and publishing complex reports. -
SQL Server – Procedures and Programming
This set of videos takes you past writing simple SELECT statements into the exciting (and geeky) world of programming in SQL Server. -
SQL Server Integration Services (SSIS) Tutorial
A series of videos designed to teach you how to export, transform and load data using SQL Server Integration Services. You can see much more on SSIS training at http://www.wiseowl.co.uk.
SSIS Review Exercise: Dump Multiple Flat Files In A Folder Into A DB Table
A tutorial on creating a SSIS package that will dump the contents in a flat file into a single database table. It means that the SSIS package will insert multiply text file into database. The video demonstrates it on old version of SSIS but the concept of passing variable as flat file name is the same and it is the main point here.
Here is the video: