Truely active passive and in the event that it does go active active you can make the cluster active passive again within 30 days?

Now as your talking about virtual nodes,...

No problem, this seems easy enough to do and would be a good learning curve as you get to learn SSIS as well. If you get stuck, come back...

Dannon

Sure, take a look in the stairways section of the site for Integration Services, it will provide you a good starting point on SSIS. Then take a look here...

One way would be to design an SSIS package which takes advantage of a variable and a for each loop set at file enumeration then you can dump the file...

Nothing at all, and no quarms against Bing or Yahoo, or any other search engine...

I dont believe you can, one thing I would say is get a copy of RSScriptor, download all the rdl files and dump them into a solution and store that...

well you dont have a login on the SQL server for the name Ashok.

I would run a profile trace, select the blank template, then select the Audit Login Failed event...

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thankyou for gave valuable information but i have one doubt as u r information you handled 12 datafiles...

there isnt any sort of impersonation going on is there, like EXECUTE AS LOGIN?

Schadenfreude-Mei (5/21/2012)

---

anthony.green (5/21/2012)

---

Schadenfreude-Mei (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like...

JaffaCakes

Schadenfreude-Mei (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls...

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls tell...

You CANNOT create mirroring on the same instance, it has to be different instances