Read, Write and Execute permissions in your case.

Does the credential (mapped to the proxy user account) have permissions on the folder aba_syms (read permissions on networked resource?). I had a similar problem, turned out that the credential...

Do you have a proxy and credential created? and is that proxy account running the job?

- Take two sources, pre-sort them in the SQL Command and set the SortKeyPositions appropriately.

- Use a merge (left) join on the keys.

- use a Conditional split and...

Use the Execute Package Task (3 times for your 3 packages) in a Main package and use SQL Server agent job to run this package. But if u want each...

You can keep the same connection. Try to run your four operations as parallel tasks (do not use workflows to govern their behaviour, or put them disconnected in a container...

Have u used options like Fast load in the data flow task, optimizing the oledb source adapters to allow more network packet size (to 32K) instead of the default 4K...

Also, what did u set the result set as?

Try this

SELECT COUNT(*) FROM MASTER.DBO.SYSSERVERS WHERE SRVNAME = ?

Leave the mappping as is.

The only hypothetical reasons that i can think of from the desc of your problem are

1. network throughput: maybe u r maxing out on this or not using it right.

2....

You need to set up a proxy account (mapped to a Credential) with permissions to SSIS sub system. Then run the job via the proxy account. This should solve your...

can u pls give the entire error msg.

Most probably your antivirus program is blocking the email out port (25).

can u post your smtp connection string?

Although very easy (the earlier post), i would recommend, u know to get your email list values from a database table, flat file etc, so that it saves u the...