Are you sure the connectionstring is set up properly in the xml file?

I havent really played with xml configurations, but I use SQL server configurations extensively and normally if I...

When you deploy to your production box, are the production configurations found on the same location as the test configurations?

How are you dealing with saving sensitive info? Have you disabled...

If you click on the plus sign on your job, look at the error message for the actual step, this should provide you with more info.

Also consider using package logging,...

How are you reading the connection string from SQL? Via package configurations?

This could be solved outside of SSIS as well...

With a TSQL subselect, you could get the first Account for a CustomerID

Something like so

select whateveryouneedhere

from customers as c

inner join accounts as...

You could work with event handlers.

You would have to enable package logging, and make this write to some kind of log.

Then in the OnError event have a send mail...

I had a look at your package, and as I said before, the connectionstring means squat in the for each file enumerator.

If you look at Excel Connection Manager 2,...

South African Public Holiday, so didnt get a chance to look at this posting.

I am confused here....

So you want the for each file enumerator to process even if there is...

Where exactly did you achieve success?

Can you connect with your userid and password to...

When exactly are you experiencing this error?

When you run this in designer mode or after the package is deployed? Remember that SSIS will not save sensitive info by default...

Why not simply create a permanent table, do whatever you want to do, and drop the table when you are done?

Temporary tables are unique to the session, and are dropped...

The FTP Receive Files Operation gets all files on a specific path.

Little note here, it is not flexible when you need only specific files. However, if you need all the...

Is this activex script task issue not related to your lookup issue.

If so, please dont cross post

Yes you can,

Either use the merge join transform or the lookup transform. Careful though, both these require sort components on both inputs which may slow your package down, depending on...

Okey,

I decided to write a sample .dtsx and post it here, complete with 3 sourcefiles, which I simply want to import to an OLEDB destination and then to move the...