IT Knowledge

Merge Join Transformation Left outer join : Includes all rows from the left table, but only matching rows from the right table. You can use the  Swap Inputs  option to switch data source, effectively creating a right outer join. Full outer join : Includes all rows from both tables. Inner join : Includes rows only when the data matches between the two tables.

First Steps to create a Package\ Lessons on video are on http://www.wrox.com/WileyCDA/Section/id-814197.html 1) Create a Connection Manager This will create a connection for the project or the entire solution. This can e change in the properties. 2) Define the Control Flow Define the tasks Recommendation - Change the default name for something more explicit 3) Package Encryption The XML by default have a default encryption using Windows user key To change use, Properties Panel -> EncryptSensitiveWithUserKey Review the encryption when deploy in a productive environment 4) Upgrade your package Variables In the blank space, left click and select Variables. Then some window will be open to declare the variables. Script Task Examples of code: In Visual Basic, creating a variable Dts.Variables(“strFileName”).Value = strInternal In Visual Basic, reading default variables. Dts.Variables(“strFileName”).Value = “newvalue” M...

SSIS - Basic Concepts Tasks Bulk Insert Task—Loads data into a table by using the BULK INSERT SQL command. Data Flow Task—This is the most important task that loads and transforms data into an OLE DB Destination. Execute Package Task—Enables you to execute a package from within a package, making your SSIS packages modular. Execute Process Task—Executes a program external to your package, like one to split your extract file into many files before processing the individual files. Execute SQL Task—Executes a SQL statement or stored procedure. File System Task—This task can handle directory operations like creating, renaming, or deleting a directory. It can also manage file operations like moving, copying, or deleting files. FTP Task—Sends or receives files from an FTP site. Script Task—Runs a set of VB.NET or C# coding inside a Visual Studio environment. Send Mail Task—Sends a mail message through SMTP. Analysis Services Processing Task—This task processes a SQL Server A...