Using SET in the command line is often not the best way to configure your packages. Reasons for this IMHO are that you are increasing the potential for error by configuring...

Stephen is right, what you're describing there is a perfect candidate for the unpivot task.

Let me know if you want help configuring it.

If its a simple inner join you could use a lookup transform and use your SQL OLE DB datasource as a reference. Any records that are found will come through the...

How have you configured the connection manager?

Have you set the quoted identifier and specified the columns that have one?

If this isn't the issue and you want to automate nicks solution,...

I have had problems like this in the past and what I have done is read the source file into a loader file using a script component.

I wrote a function...

Hi Vitali,

You would use the Merge Join transformation in SSIS.

In order to use this component, both the meta data and sort columns need to be the same for both inputs.

Sounds about right, but if that is what you're doing your easiest solution would be a derived column component.

Simply drag the pipeline from the conditional split into a derived column component....

Are you sure that this can't be done using expressions and the conditional split component?

If you really have to use script then, you are going to need a transformation script component.

1. Drag a...

For debugging you may get more useful info by remoting on to the SQL Server copying the command line from the Step in the Job into DTEXECUI and executing it.

If...

Note also that if this is a SQL Server table, there is a PIVOT and UNPIVOT option in T-SQL. You may find this easier to implement than the un/pivoting components...

The connection manager for excel uses the Excel Jet Driver. What this does when you create your source and destinations is sample the first 8 records and based on what...