you are very welcome, glad I could help.

CEWII

I think all of those are good answers..

CEWII

ryan213 (12/17/2009)

---

I know this is an old thread, but I'm having the same issue. Is there any way I can specify which email credentials for the SSIS Send Mail...

That I don't know, it depends on what it used to do the encryption, if it just used something like domain\user then it will prbably work, if it used the...

Been there, done that..

CEWII

I'd probably change my select query from the staging and do a distinct and only include the fields I needed. This should weed out dupes and make the database...

There is a max errors setting on your foreach loop, I bet it is set to 1, set it higher. You could try 0 but I don't know if...

Baskar:

It isn't the query that is the problem, but the connection information required to satisfy the query that gets encrypted. And can only be decrypted by the same user...

rdevitta (8/24/2010)

---

I'm having a very similar problem.

I have a job with only one step, that invokes a ETL package.

The ETL deletes some data from the data base (Execute SQL Task)...

RonKyle (8/7/2010)

---

These kinds of statements make me nervous....

Unfortunately that is pretty typical since it is usually run in production as a different user than was used to develop it..

CEWII

I have done this before with SSIS 2005, it is easier with SSIS 2008..

In the Lookup comopnent for 2005 you have 2 outputs, found and error. In 2005 I...

chris.thornburg (8/18/2010)

---

Thanks..but he is no longer with the company and his machine has been wiped and is not available...can I open the package as XML in notepad and change that...

Take a look here and see if it helps:

Here

CEWII

How about these two articles:

Concurrent processing in SSIS – Part 1[/url]

Concurrent processing in SSIS – Part 2[/url]

CEWII