You could store all the differents paths in a table and then loop over this table with the foreach loop container.

Map the string value in a row to a string...

That is because the variable will be filled in when your package is running, not when you are designing it.

You can solve this by putting the correct value in the...

Although it is not very secure, that should do it.

Microsoft discourages the use of Local System as account though:

http://msdn.microsoft.com/en-us/library/ms191543.aspx

What is the specific error that you get when you try to...

Create an Execute SQL Task that reads your table with the filepath. Store the result in a string variable using ResultSet -> Single Row. Connect the SQL Task with the...

Go to SQL Server Configuration Manager and see which account the SQL Server Agent uses.

Then make sure that this account has read (and if needed, write) permissions on the folders...

You are trying to convert a unicode string (DT_WSTR) to a non-unicode string (DT_STR).

If there are unicode characters that are not found in the code page of DT_STR (like the...

Here you can find some documentation on data sources:

http://msdn.microsoft.com/en-us/library/cc671619.aspx

There is also a section about the disadvantages of using them.

So indeed, the advice is not to use them, but use connection...

Has the SQL Server Job Agent account access to the specified path?

Maybe he hasn't the permission to read files in that folder.

I think that if you use an OLE DB Command in your data flow, there will be a commit after each single update (as the OLE DB Command will issue...

If the data in a column is of mixed datatypes, you should put the IMEX=1 option in your connectionstring.

For example:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\myServer\myExcelFile.xls";Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

This will force the Jet adapter to read...

My first idea:

read the table with the SQL statements with an Execute SQL Task and store the results in a recordset. This recordset is stored in an object variable.

Then use...

Import the column as text (make sure that you use the intermixed option in the connection string. Be careful, importing mixed data types can cause a lot of trouble. There...

You should never post your e-mail like that on publicly accessable forums like this one, unless you like receiving spam.

Put it up like this:

myName at myServer dot com

You can read this forum, you'll find plenty of issues here 🙂 (and in most cases, also their solutions)

Are that the only errors that you receive?

If the Execute Package went red, that there must be some sort of error that would explain why it has failed.