Viewing 15 posts - 7,876 through 7,890 (of 11,678 total)
Eugene Elutin (2/21/2012)
deepkt (2/21/2012)
Thanks for the reply Eugene Elutin.Is there any other way without configuring Ad Hoc Distributed Queries option?
Thanks
No! There is none!
But I still don't understand what you are...
February 21, 2012 at 4:58 am
Tee.M (2/21/2012)
Does this by any means temp with the oracle drivers?
I installed this for my clients and right after they complained about oracle drivers (haven't looked the error message yet),...
February 21, 2012 at 3:53 am
deepkt (2/21/2012)
Thanks for the reply Eugene Elutin.Is there any other way without configuring Ad Hoc Distributed Queries option?
Thanks
Stored procedures actually do not have an explicit metadata contract.
If you do want...
February 21, 2012 at 3:51 am
paul.knibbs (2/21/2012)
Weird. I *have* had to do this a couple of times myself and it's worked fine...no idea why it didn't for you!
Beats me either. Like I said, I probably...
February 21, 2012 at 1:12 am
paul.knibbs (2/21/2012)
Koen Verbeeck (2/21/2012)
February 21, 2012 at 1:09 am
I had to use this method once, but I still couldn't log in as I always got the error that someone was already logged in (and this was not the...
February 21, 2012 at 12:58 am
That's unfortunately not how config file works. If you would encrypt it, the SSIS package cannot use the contents any more. You probably want to use the script task to...
February 21, 2012 at 12:25 am
Where do you need to encrypt it? (where are you planning to store the username and password?)
February 21, 2012 at 12:03 am
I don't really like SSIS packages having direct user input. I would rather develop a small .NET application that has the datepicker that starts an SSIS package providing a few...
February 21, 2012 at 12:01 am
Nice question, but I think you can restore to a point-int-time in the Bulk Logged Recovery Model as long as no bulk logged operations are present in the backup.
MSDN:
Under the...
February 20, 2012 at 11:58 pm
Please read this article on how to post questions on the forums:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Also, your caps lock is broken.
February 20, 2012 at 1:51 pm
Add a dataviewer in your dataflow. (right click on an error, choose Dataviewers).
If you run the dataflow, do you see the correct data in the dataviewer?
February 20, 2012 at 12:21 am
Phil Parkin (2/18/2012)
subhaannai (2/17/2012)
For Example :
If my data soruce returns 10,000 records,
inside my script component im...
February 20, 2012 at 12:18 am
dndaughtery (2/18/2012)
February 20, 2012 at 12:17 am
Well, it's because it is not the OLE DB Destination itself that is having an error, it is the database engine that is throwing back an error.
What is the difference?...
February 20, 2012 at 12:12 am
Viewing 15 posts - 7,876 through 7,890 (of 11,678 total)