Bit of a trick question - as it has nothing to do with sorting - but learned something. Thanks.

No problem, glad to help.

Elliott Whitlow (12/12/2011)

---

I have had people say I'm crazy but thats just fine.. I think this methodology needs a bit more baking time before it is scrapped but it...

What happens if you step through the script with the debugger?

Brrrr... Oracle.

I spent 4 hours yesterday setting up an Oracle client on the...

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider...

Charmer (12/12/2011)

---

Koen Verbeeck (12/12/2011)

---

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider each time you...

John Mitchell-245523 (12/12/2011)

---

I searched the internet for "create solution in bids". If you do the same,...

You can use the standard built-in logging for that.

The only thing you need to do is change the connection manager for the log provider each time you run the package,...

You need to add the package to an SSIS solution in BIDS in order to debug it.

Elliott Whitlow (12/9/2011)

---

Wow, thats an interesting request.. I question the methodology but ok..

I would use a data-flow task. The rows are generated by a source and a script...

You should also do that when you are not using CozyRoc but regular SSIS tasks dealing with Excel.

Doesn't have...

There isn't a lock on the file or something like that?

OK, disregard my question about the connection manager. It is not pointed at a dbf file, but at the folder that has those dbf files.

Regarding the error:

you probably get that...

You need to run the package that contains the Cache Transform to refresh the cache.

http://blogs.msdn.com/b/mattm/archive/2008/11/22/lookup-using-the-cache-connection-manager.aspx

Make sure you also read the references at the bottom of the article.