Please explain what you want to your package do. Sorry but it is difficult to analyze code ;).

Powichrowski Marek (12/5/2007)

---

Yes, right, this table is create by statement "select * into...". I why this error occur. Your select query for the destination does not return rowset at...

Yes, right, this table is create by statement "select * into...". I why this error occur. Your select query for the destination does not return rowset at all.

Destination query...

Probably your package try to add record with invalid data in foreign key column (value does not exists in referenced table primary key).

May be to use conditional split component from source and on this basis add destinations for each condition?

I think the best way is use multicast component from ODBC source (joined SQL query as source of data). So place it on the Data Flow tab surface and add...

Ahmet Akin (6/29/2006)

---

The Package works really fine, when i run my Package local, the flatfiles had been sent successfully to the FTP-Host.

But as i start the Package from the Management...

ATH00888 and structure tables has the same structure and even column names are on the same positions in both tables?

I think "strict on" is safely.

I think the best way is to use Script Component data flow transformation (with script type set to transformation).

0. create variable ColumnsNumber,

1. put this component od the Data Flow tab...

And ATH00888 exists too?

Check if OLE DB Destination has valid connection to destination server and are those tables exists on the destination database.

Please put OLE DB Source component on the Data Flow tab surface, double click on it and click on "Data access mode" drop down list, and the last option is...

I think you must use "SQL command from variable" option when accessing this query from OLE DB Source an point to variable name from Variable name drop down list. Value...

OK, so what is your problem when creating Execute SQL task using ForEach container under SSIS?