Well, I'm assuming you want to read data from 6th row onwards and then export this to some destination.

Why don't you first dump the excel into a staging table ,...

You need to take care of two things while using Merge Join in SSIS :

1) Is Sorted is set to "True" and Sort Key is defined on the sort column

2)...

Agreed with Koen.. But instead of writing the header manually once (i.e. if you want the whole thing to be automated) you can do this :

1) Create a file say...

I agree.. Use "Retain null values from the source as null values in the data flow" in flat file connection manager.:-)

I believe by Row number you mean total number of rows in the source file.

There's a pretty easy way of doing this ... below is a script to help you...

You can probably use notepad++ to edit xml files (it's also useful for loads of other languages too).

Not sure why the username is not displayed betwwen the <ConfiguredValue> & </ConfiguredValue...

This is perhaps the only way (most people know of).

BTW , why are you looking for an alternative way of doing this?

Well , i can suggest a workaround for this.

U can try and see if you get the desired result.

Here's what you can do :

Inside the DFT you must be...

I agree with the above views that this won't be possible inside a single Data Flow Task , because you cannot set expressions on precedence constraint inside a DFT.

This is...

Sorry for the confusion.

"Pick up the columns" as in decide the columns on which you want to create row groups.

Depending on the data you will have to decide the columns...

I believe the article is quite explanatory,but i do agree with you on the fact that Microsoft tutorials do get a bit confusing with all the links and subsections they...

You can easily achieve this using row groups....

Use part# to group rows..

Yeah!! Maybe you're right...Even i have started to believe this can't be done..

As to why i want it this way -

The whole report is clouded with report items and...

It is not clear as to what exactly you are trying to do...

However i suppose it is similar to this:

You want the user to be able to enter different values...