Category: SSIS

Study resource for SQL Server 2008 R2 Integration services (SSIS)

Study resource for SQL Server 2008 R2 Integration services (SSIS)

  SQL Server 2008 R2 Integration services (SSIS) Creating a simple ETL Package http://msdn.microsoft.com/en-us/library/ms169917.aspx Typical Uses of SSIS Packages http://msdn.microsoft.com/en-us/library/ms137795.aspx Package Protection Level Setting: http://msdn.microsoft.com/en-us/library/ms141747.aspx Running Packages: http://msdn.microsoft.com/en-us/library/ms141708.aspx Logging Package Execution: http://msdn.microsoft.com/en-us/library/ms139845.aspx Architecture of...

Convert Date into Integer like YYYYMMDD in SSIS package

Convert Date into Integer like YYYYMMDD in SSIS package

i used following Expression in  Integer values expression shap   (DT_WSTR, 4) YEAR( @[User::StartDate] ) + Right(“0″+ (DT_WSTR, 2) MONTH( @[User::StartDate] ) ,2) + Right(“0″+ (DT_WSTR, 2) DAY( @[User::StartDate] ) ,2) It convert the...

How to convert date to interger In TSQL

How to convert date to interger In TSQL

During my assignment I have to generate Integer value from datetime filed for Date Dimension . I found excellent  id this way.     CAST(CONVERT(varchar(8),StartDATE,112) AS int) DateDateKey,   The whole Query is  as follow.  ...

SSIS Community Tasks and Components

SSIS Community Tasks and Components

There are hundreds of free SSIS tools available, which provide additional functionality. Codeplex listed them as http://ssisctc.codeplex.com/. These divided into following sections Tools Connection Managers Log Providers Task (for Control Flow) Foreach Enumerators Script...