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

2005...