
Learnng resources
Keywords
- Big data, Bigdata, Big-data, MongoDB, Mongo DB
- NoSql, No sql, No-sql
- Training, Train, Learning programming, learn,
- Programming languages
At the following link you will find Video Tutorials of:
1. C#
2. SQL
3. SSIS
4. SSRS
http://www.wiseowl.co.uk/videos/
http://aniruddhathengadi.blogspot.co.il/2011/12/how-to-automate-cube-processing.html
Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
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/
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
http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
http://stackoverflow.com/questions/15406424/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: