I know u used DontSaveSensitive, but when u created the pkg, did u enter any password?

I am not sure of sending to a list 'all at once', but can help with sending one at a time in a loop using ForEach and create a custom...

Does your SMTP connection have any (SSIS) configurations?

may give problem in qry, try running it before your execute proc statement "SET FMTONLY ON; EXEC "

Try using the SET FMTONLY option in your query. It should work.

Try removing exclusive locking from tables in your Data flow tasks.

So...you want to create a configuration file for other configuration files??

Is the CID mapped to LONG or NUMERIC. ..... it shud be LONG (if it is integer)

Use derived columns in dataflow task with GETDATE function.

Give the user\job owner access to db_dtsoperator role in msdb database or use proxy accounts for executing thru a ajob.

Use an environment variable (Indirect configuration in Package configurations) to point to your configuration file. Use the environment variable in all your 8 packages, they will reference the same file...

Lookup proxy accounts and running SSIS jobs.

Is your path coming from a package configuration? If you do have it as a pkg config, Did u restart BIDS after u added this variable?

Try changing your where clause to use an exists

WHERE SomeIntVal IS NULL OR SomeIntVal NOT EXISTS(SELECT 1 FROM FROM table2 WHERE id = SomeIntVal)

hope you have SomeIntVal indexed.

vishal.gamji (2/3/2009)

---

vishal.gamji (2/3/2009)

---

Can you add another ExecuteSQLTask that executes the query:

SELECT ? = TOP 1 1 FROM

create a variable for the ? and change the resultset of this...