Viewing 15 posts - 4,981 through 4,995 (of 6,400 total)
Yes, take a look at the link and there is plenty of good Google articles on it as well.
May 22, 2012 at 4:44 am
Could you not use the unpivot task in a DFT to do it?
Could also do a Google for "dynamic unpivot tsql", as it looks like the SSIS Junkie has already...
May 22, 2012 at 4:07 am
Excellent find downloaded and put in my e-book repository
Might be worth wrapping the url in the URL IFCode tags to make it easier for people to follow the link.
May 22, 2012 at 3:07 am
k.subramanyam1017 (5/22/2012)
Thanks to given answer but my client said how to find out slow runnig queries or long execution queries(i dont know which query...
May 22, 2012 at 3:03 am
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,...
May 22, 2012 at 2:43 am
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...
May 22, 2012 at 2:38 am
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...
May 22, 2012 at 2:32 am
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...
May 22, 2012 at 2:18 am
michael vessey (5/22/2012)
Koen Verbeeck (5/22/2012)
Or Bing!(or even Yahoo if you must)
hey - what's wrong with askjeeves.com
Nothing at all, and no quarms against Bing or Yahoo, or any other search engine...
May 22, 2012 at 2:05 am
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...
May 22, 2012 at 1:58 am
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...
May 22, 2012 at 1:28 am
k.subramanyam1017 (5/21/2012)
Thankyou for gave valuable information but i have one doubt as u r information you handled 12 datafiles...
May 22, 2012 at 1:20 am
there isnt any sort of impersonation going on is there, like EXECUTE AS LOGIN?
May 21, 2012 at 8:19 am
Schadenfreude-Mei (5/21/2012)
anthony.green (5/21/2012)
Schadenfreude-Mei (5/21/2012)
k.subramanyam1017 (5/21/2012)
Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like...
May 21, 2012 at 8:11 am
Viewing 15 posts - 4,981 through 4,995 (of 6,400 total)