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) – 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.
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
How to load a variable from “Execute Sql Task” in SSIS package
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: