Blog

SQL SERVER SSIS: Get File Name with Flat File Source, Data Flow Component
12-Apr-2010
SQL SERVER SSIS: Get File Name with Flat File Source, Data Flow Component

As I explained earlier about For Each Loop Container, which process each file from selected folder.

15-Mar-2010
SQL SERVER: Execute Stored Procedure when SQL SERVER is started

We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.

SQL SERVER: SSIS - Derived Column Data Flow Transformation
11-Jan-2010
SQL SERVER: SSIS - Derived Column Data Flow Transformation

As I explained earlier about Foreach Loop Container. One of regular reader of blog send me an email about one issue.  

28-Dec-2009
SQL SERVER: How to remove cursor

Many times developer ask me that How can they remove Cursor?  

SQL SERVER: How to Read Excel file by TSQL
23-Dec-2009
SQL SERVER: How to Read Excel file by TSQL

Many times developers asked that, they want to import data from Excel file.

SQL SERVER: SSIS - Transfer Jobs Task
16-Dec-2009
SQL SERVER: SSIS - Transfer Jobs Task

The Transfer Jobs task can be configured to transfer all jobs, or only specified jobs. You can also indicate whether the transferred jobs are enabled at the destination.

SQL SERVER SSIS - For Loop Container
25-Nov-2009
SQL SERVER SSIS - For Loop Container

Today, I am going to explain SQL SERVER SSIS, For Loop Container.

SQL SERVER SSIS: How to assign Connection from variable
15-Nov-2009
SQL SERVER SSIS: How to assign Connection from variable

Last Article, SSIS - Foreach Loop Container, We need to assign dynamic connection to file connection, so SSIS For each loop Task can take each file from folder.

SQL SERVER SSIS: Basic Example Of Data Flow Task
22-Oct-2009
SQL SERVER SSIS: Basic Example Of Data Flow Task

Today I am going to give Basic example of Data Flow Task in SSIS, import CSV file to SQL SERVER Database Many times user asked to import their data from their files. They might have data in Microsoft Access, Microsoft Excel, CSV File, Text Tile etc..

22-Oct-2009
SQL SERVER: What is SSIS?

SSIS (SQL Server Integration Services) is an upgrade of DTS (Data Transformation Services), which is a feature of the previous version of SQL Server