
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
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: