Use the aptly named FileSystem Task.

Create a variable that builds it's new name from an expression.

can you logon to the server and run it interactivly?

If so, open CMD and set your path as "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn" or whereever you installed SQL.

Using that dtexec,...

Nothing to be sorry about. Post the source data, screen dumps of the derived column and we will help. That is why we are all here.

Cool - will sort out something on codeplex. See what happens.

As for MSIs, I did a stint with a company that used them. Used Wix to create them rather successfully....

I would agree with you there. It is a bit. I suspect there are many many home built config editors out there. Maybe work a community project on CodePlex...

Please (not plz) don't ask us to hurry along. People help people here in their own time. Nothing else.

If you say the code does bot work, post some examples of...

I disagree.

There is nothing you cannot do. Granted, you have to edit the config file but that is a simple task with notepad or any number of free xml...

It's for that reason that storing packages is MSDB is rubbish.

File based packages are much nicer. Simpler to manager, (don't claim backup reasons), execute etc etc. When editing them, equally...

Most languages & and | are bitwise AND and ORs and && and || are logical.

One that catches me is the == and =

If MyVar = "123" will ALWAYS be...

Read up on them in BOL and the answer will become evident.

Is your test server 64 bit?

JET does not work with 64 bit.

Can the test server see the xls file?

The conversion has to be done on a new, derived, column. The resultant should be date.

Is use (DT_DATE)(SUBSTRING(Col11,4) + "/" + SUBSTRING(Col15,2) + "/" + SUBSTRING(Col1,7,2))

which breaks it into a...

&& instead of &

The end of the post looks like keyboard corruption 🙂

Ok, so the client is not running the package - they are simply asking for it to be run. There...

Just read the last two posts - It appears you are using 64bit ssis and Excel. Jet is not supported on 64 bit. Either run the package with 32bit dtexec...