sqlyoga.com
April 2014 ~ SQL Yoga
http://www.sqlyoga.com/2014_04_01_archive.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. April 17, 2014. SQL SERVER: SSIS – Merge Join Transformation. Now, let’s have a look at functionality of Merge Join Transformation. Merge Join Transformation has two inputs and one output. It does not support an error output. Use of Merge Join Transformation:. To Understand Merge Join Transformation. 1 Create sample tables:. 3: Dept No INT. 30, ' SALES.
sqlyoga.com
SQL SERVER: SSIS - Foreach Loop Container ~ SQL Yoga
http://www.sqlyoga.com/2009/11/sql-server-ssis-foreach-loop-container.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. November 9, 2009. SQL SERVER: SSIS - Foreach Loop Container. For Each Loop Container. Today, I am going to explain SSIS For Each Loop Task. I am sure that it will be easy to configure SSIS Package with Foreach Loop task, after you read this article. SSIS Foreach Loop Container. SSIS Foreach Loop Container. Select the enumerator type from the list....
sqlyoga.com
August 2014 ~ SQL Yoga
http://www.sqlyoga.com/2014_08_01_archive.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. August 6, 2014. SQL SERVER: Clone SSIS Package. Please find following steps to achieve the same:. Right click on existing package and click on copy option and after right click on SSIS Packages folder and Paste on the location. Rename Package Name for newly Pasted file:. 4 Open package in Notepad Editor:. 5 Replace package Name in Notepad file:. Today...
sqlyoga.com
April 2015 ~ SQL Yoga
http://www.sqlyoga.com/2015_04_01_archive.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. April 4, 2015. SQL SERVER: Find Current Location of Log File(s) with File Size of All the Database. Current location of log files. SQL Log file size. SELECT d.name As DatabaseName,. Mname As FileName,. Mphysical name As PhysicalFileName,. Msize * 8.0) / 1024 / 1024 As SizeInGB. FROM sys.master files m. WHERE m.Type = 1. Subscribe to: Posts (Atom).
sqlyoga.com
June 2015 ~ SQL Yoga
http://www.sqlyoga.com/2015_06_01_archive.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. June 1, 2015. SQL Server, avoid encoding special character when using FOR XML PATH. For XML PATH TYPE. From SQL 2005, we are using FOR XML PATH(' ) for the string concatenation. I have also mentioned the same in very old blog: Generate Comma Separated List with SELECT statement. Eg: Table has records like:. 1 Gynecology and Obstetrics. Today I have th...
sqlyoga.com
SQL SERVER: Generate Comma Separated List with SELECT statement ~ SQL Yoga
http://www.sqlyoga.com/2009/02/sql-server-get-comma-separated-list.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. February 28, 2009. SQL SERVER: Generate Comma Separated List with SELECT statement. Today I have the following situation, where I need to display all related data in comma separated list. I have Table like:. CREATE TABLE #test( field1 VARCHAR(5), field2 VARCHAR(5) ). Lets insert some data in this table:. So now my table has Data like:. Super result Te...
sqlyoga.com
SQL SERVER: SSIS - Rename and move files from source folder to destination folder ~ SQL Yoga
http://www.sqlyoga.com/2014/09/sql-server-ssis-rename-and-move-files.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. September 4, 2014. SQL SERVER: SSIS - Rename and move files from source folder to destination folder. Process all files with SSIS. To configure Source folder and Archive Folder by variable. Example :- c: Source Folder). Example :- c: Archive Folder). 2 Set variable’s properties expression:. User: SourceFolder] " " @[User: FileName]. User: TargetFolder...
sqlyoga.com
March 2014 ~ SQL Yoga
http://www.sqlyoga.com/2014_03_01_archive.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. March 31, 2014. SQL SERVER: SSIS - Look Up Transformation Task. Today, I am going to give basic example of Lookup Transformation Task in SSIS. Use of Look up Transformation:. Let’s take an example to easily understand how to use Lookup Transformation in SSIS. 1 Create Source Connection:. Select and drag “ Data Flow Task. 2 Create sample tables. 17: ,(...
sqlyoga.com
SQL SERVER: How to Read Excel file by TSQL ~ SQL Yoga
http://www.sqlyoga.com/2009/12/sql-server-how-to-read-excel-file-by.html
This blog is for SQL SERVER developers. Here I am trying to share my experience with all people. This blog contains my thoughts that might help the people. December 3, 2009. SQL SERVER: How to Read Excel file by TSQL. Many times developers asked that, they want to import data from Excel file. We can do this by many ways with SQL SERVER. 1 We can use SSIS package. Today, I am going to explain, How to import data from Excel file by TSQL. To import Excel file by TSQL, we need to do following:. December 24, ...