I have to admit I like that method.

CEWII

Using a Script Task you can send email with this code as the basis:

Code to send mail for SSIS:

Dim _oSMTPClient As New SmtpClient("smtpmailhost.yourcompany.com")

Dim _oMailMsg As New MailMessage()

_oMailMsg.From = New MailAddress("someemailaddress@yourcompany.com")

_oMailMsg.To.Add("someotheremailaddress@yourcompany.com")

_oMailMsg.Subject...

You might translate this line:

Description: "Impossibile recuperare una riga dal provider OLE DB "BULK" per il server collegato "(null)".".

I think it is the basis for the problem..

CEWII

SSIS is not really instance aware, in other words even if you have 3 SQL instances on a server you only have 1 SSIS server.

Now the tricky part is that...

Given that error message, you might verify that the dtsConfig file hasn't been corrupted, it doesn't take much, a > out of place can do it.

My thought is tied to...

Even in this case, the SSMS may be trying to auto-save to a non-local location. You'll have to look into the options to see where the autosave location is.

CEWII

Have used a similar method before, only real difference is that ALL the config files were source controlled, and the DEV provided them all.

Have you verified the package is configured...

I have also seen it when the "My Documents" folder for the user's profile is on an Offline Folder such as the users network home directory.

CEWII

You can use a script task to do it, here is the basis for the code:

Code to walk through OLEDB data..

Dim _oOledbAdapter...

Sounds good.

CEWII

Different idea. Use service broker to instantiate 8 seperate sessions and then return the results.

CEWII

Not to put too fine a point on it, but the resolution is to not use SQL Mail. Since we are in a SQL 2005 board you should be...

And here is the ruling on Processors vs. Cores:

http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx

CEWII

Cores vs. CPUs is an important distinction..

Please see:

SQL 2005 Edition Feature Comparison

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

CEWII

You are welcome. It is so often something small that causes issues. I sometimes feel bad asking the really basic questions.

CEWII