Back again with another SSIS SQL Server based configuration problem. I was using SQL server based configuration and the SSIS configuration wizard created one table with the default field lengths. The table is like this: CREATE TABLE [dbo].[SSIS Configurations](     [ConfigurationFilter] [nvarchar](255) NOT NULL,     [ConfiguredValue] [nvarchar](255) NULL,     [PackagePath] [nvarchar](255) NOT NULL,     [ConfiguredValueType] [nvarchar](20) NOT NULL ) … More the connection string format is not valid . it must consist of one or more components of the form….error

Recently, I have been working with SSIS configurations a lot. At the beginning, it seemed not much difference between XML configuration and SQL server configuration to me. Very quickly, I was proved wrong. In the configuration wizard, we can choose several properties of a connection; i.e. Connection String, User Name, Password, Server Name, Initial Catalog … More Password must be included in connection string for SQL server based configuration in SSIS

SSIS Data Flow Task is strictly meta data bound. Input table’s columns are mapped at design time. Let’s say u have a table (Table_1) where column names (JAN,FEB,MAR) are dynamically changed and u don’t have any control over it. SELECT * FROM dbo.Table_1 returns ID    JAN    FEB    MAR 1    100    200    300 2    400    500    600 3    700    800    900 In the next month, it becomes ID    APR    MAY    JUN … More Dynamic Column Mapping in SSIS : Part 1

If you double click on the For Loop Container of SSIS, a new window will open where you can set up the condition based on which the loop will continue. There is a field called EvalExpression where you can set an expression and if this expression holds true, the loop will continue. I was just … More Logical OR Condition in EvalExpression of a For Loop Container