Do the text files all have the same structure (column names, column types and number of columns)?

Have a look here.

A pleasure to help.

No matter what happens to a variable while the package runs, when you look at the variable values in the variables pane, you will always see its initial setting, which...

The ID autogenerates - you should just be able to leave it blank and map to the other two columns, in the knowledge that it will look after itself. Why...

After your data source in the data flow, insert a Derived Column transformation.

Create a new Derived Column and assign your date variable to it.

You will now be able to create...

If you are talking purely about performance, there are many possible factors.

If you...

Why not try both and see for yourself?

I would, however, expect parallel to win...

Have a look here.

Use an expression to set the SQL string which will be executed by the task.

The expression can contain a combination of literal text and variables (system and...

tooba111 (1/19/2011)

---

I am sorry john to confuse to, that was typo mistake, In last post i asked i only need those fields who don't have null value if there is...

OK, maybe that was a bit harsh on an SSIS newbie.

After looking at this, I must admit that I found myself thinking that it would be easier to get the...

Karan_W (1/19/2011)

---

I want to create a SSIS package which will call the stored procedure and dump the output of the procedure into table.

This stored procedure accept an input parameter e.g....

It looks like you've got the same issue as this guy.

Based on the fact that it does not look like it will be very easy to solve with this approach,...

I bet you've guessed my next question already: please post what the parameters screen contains - perhaps even a screen shot if it's not confidential.

Excuse my speaking plainly, but that is a daft requirement.

What happens if the four source fields all contain different data - you have only one target, so you are going...