The ForEach loop will return the file name when the file matches the pattern given in Files field (e.g. *.txt will search all txt files in the given folder). You...

On the SSIS (BIDS top Menu item), you can find 'Package Configuration'. You can add config files here. Personally i go with XML files for configuration, there are other options...

Yes you can connect to SQL Server 2000 using SSIS. In you dataflow use OLEDB Destination or SQL Server Destination.

And for connectiing to Excel you can use the Excel Connection.

This...

I am still not sure if you are using this variable to set connection string of the file or you are just using this variable to build your xm_cmdshell command.

Either...

Are you using this variable to set connection string to a file connection? (I didn't understand your question properly, What exaclty is the issue?)

If you are trying to do this..it...

In Execute SQL Task you will have to use parameters to return values from your table. I guess you are using ODBC driver to connect to MySQL.

Your query should look...

It was my mistake i thought that you were loading data from flatfile. Please check the sql server destination data type for Quantity field. You mentioned that its Numeric (38,0),...

Is it possible that the any of the parameters for this procedure EXEC DBO.ProcOne ?,?,?,? is geting Null values sometimes that it can't handle? The datatypes for OLEDB connection...

If you are doing it programmatically then you can follow (i have never done it programmatically)

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

Otherwise, you can go the Advance Editor->Input and Output Properties(tab)->Output Columns->(select the column...

Try redirecting the error rows to see the value of 'Quantity', this might help you identify the problem further.

Also what is the datatype for your SQL server destination?

Yes its possible if the user under which the package executes has appropriate permission (to read or write) on that server.

What exactly are you trying to do with this flat file?

If you are just loading from this file it shouldn't be a problem as the comment column is your...

Is your varible InsurerID of type int? If it is then you need to convert it to string type for concatination.

"SET FMTONLY OFF EXEC PROVIDER_DIRECTORIES " + (DT_WSTR, 15) @[User::InsurerID]

HTH

~Mukti

Try setting the DelayValidation = True on Send Mail Item. I think its trying to validate it before the variables are set.

HTH

~Mukti

That sounds really very wierd. Could you please tell more about the loop, what else goes on there?

Is it possible that when you run the packages the connection changes...