This is the incorrect place to post. This forum is only for SQL Server Integration Services related issues and questions.

Okay,

I have an idea. And I think you might be able to accomplish your processing without programming. Here is what you have to do:

1. Insert data flow task.

2. In the...

I would recommend that you use script task to extract the "Total" value.

You still haven't provided details about the structure of these files. The file extensions doesn't say too much. Show an example of your data?

Can you send an example of your data? Your post contains very limited information.

Amith,

What is the destination component that you use? Certain data flow components support setting their properties thru Expressions. You can check if your destination component property can be set by...

Can you explain why you don't want to use the Sort component?

You can handle the removal of duplicates by inserting your data first in a staging table and then handling...

Use VB's MsgBox function to find out where exactly it stops. My guess is that you are trying to access a package variable, which is locked for access by another...

You probably meant: Dts.Variables("MyVarName").Value

The variable object itself is not usually used.

This information is hard to get. I would recommend that you do your own evaluation and come up with conclusions. I found one discussion in MS SSIS forum, you may...

The fastest thing you can do is use SFTP Task.

I have a question for you. When you say you want to load record from 2 data sources to 1 destination, which data source record you want to load? How...

I don't know too much about SPS. It is probably a good idea to ask that kind of question in SharePoint-related website. This forum is concentrated on SSIS.

Do not post here. Your question is being answered already in this post.

I just realized you need Excel file processing. Yes you can still use SSIS, but you have to first download the Excel file locally from SPS and then process using...