SKYBVI (6/14/2012)

---

Hi,

I have 3 doubts :-

1) If I have a SSIS package with encrypted package protection level and in data flow tasks, there is...

You might look at:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70346/%5B/url%5D

and:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70347/%5B/url%5D

CEWII

I'm with David on this..

I'd also be curious what caused the corruption in the first place..

As a further question, why are you still using SQL 6.5?

CEWII

I think I would immediately copy all the data out of that table that I could get. Otherwise you could easily lose it all.

Also do you have a good...

You are welcome.

CEWII

Listen the redirect shouldn't fail the data-flow, thats its purpose.. You can use the redirect on error to either write the records into a holding location or depending on...

If you redirect error rows the Data-Flow task should not fail. did I misunderstand?

CEWII

I believe Daniel is correct, in this scenarion there ISN'T an error, its a problem that is managed. So you can have one or the other but not both.

CEWII

I would think it is probably possible to complete IF the password (I'm guessing thats the hangup) is set using a config method like files or passed in or something....

Glad we could help..

CEWII

Lynn Pettis (5/23/2012)

---

michael vessey (5/23/2012)

---

ahem.... the tester didn't put the defect...

jswong05 (5/23/2012)

---

You can find the documentation on SQLServer2008R2 BOL.

This is one of the stupid design.

Imagine old days, you go to library asking for a book for a page you need....

Jim,

I might point out this is a nearly 3yo thread..

I might suggest that it would be a good idea to start a new thread..

CEWII

Oliiii (5/23/2012)

---

Where i work, when you fix something you have to usually show why it was like that, what you did to fix it and why the dude developing it...

Do you verify the backup? What other items are in that maint plan sub plan that could cause a failure?

CEWII