Category: SSIS
-
Big Data / NoSql
MongoDB Tutorials Tutorial 1 (guru99) Terms Quick Reference show dbs – show all dababases show collections – show all collections in database. use [db name] – switch to the specific database. db.[collection].find() – find records in the collection. db.[collection].find({email:”[email protected]”}) – find specific value db.[collection].findOne() – find one record in the collection. db.[collection].findOne({email:”[email protected]”},{password:”12345″}) – find specific…
-
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
https://msdn.microsoft.com/en-us/library/hh213230.aspx https://www.simple-talk.com/sql/ssis/ssis-2012-projects-deployment-configurations-and-monitoring/
-
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…
-
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
http://www.wiseowl.co.uk Direct Link to youtube homepage Direct Link to SSIS Subscribed WiseOwlTutorials Home Videos Playlists Channels Discussion About What to watch next 21:44SQL Server Integration Services (SSIS) Part 11 – Looping Over Files by WiseOwlTutorials 6,422 views 10 months ago 19:35 SQL Server Integration Services (SSIS) Part 19 – Parameters and deployment by WiseOwlTutorials 4,690…
-
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…