Great! And there is no need to store any kind of variable in this solution.

(and admit, VB or C# is probably a lot easier than...

Well, I don't have any experience in Performance Point, but I would certainly be interested in a data mining forum!

Or, just to add another option:

1. Add a script task.

2. In the script, create a directoryinfo on the directory. (let's name it di)

3. Use the getfiles method: di.getfiles() and store...

Hmmm, not so great question, but on the other hand, it ignited a great discussion.

I got it wrong, because I don't think having columns that allow NULLs are per definition...

That is a great ideo of Jack, but I'm not sure how you can make it one big delete statement instead of a lot of different small delete statements (each...

Nice question. Although the first answer is also a bit valid, as both transactions are indeed rollbacked. (due to the outer transaction)

Raunak Jhawar (9/20/2010)

---

NULL can have different meaning when it comes to EXCEL and SSIS

I would advice you to convert all non available fields to some fixed value for instanve say...

The easiest solution is to select the Retain null values in the source as null values in the data flow option in your flat file source.

Phil Parkin (9/21/2010)

---

steveb. (9/21/2010)

---

With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script...

1. Yes. An example: http://www.texastoo.com/post/Create-a-custom-assembly-in-SSIS.aspx

2. Yes. You can use the Web Service Task. (what's in a name?)

For all the rest, I refer you to the almighty Google.

Connect with SSMS to Integration Services and locate your package. Right-click, select Delete.

Then deploy your package again from BIDS.

You are right about the fact that you can only see the...

Are you sure your environment and the server environment are 100% the same?

It seems to me that there is a default constraint on the table at the server.

If the Lookup components has multiple matches for one row, it will only return the first one!!!

So you cannot achieve what you want with a standard lookup component.

You can implement...

These days we just call them "bosses". 🙂

Great question!