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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

The variable object itself is not usually used.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

The fastest thing you can do is use SFTP Task.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/