May 10, 2012 at 1:06 pm
Lynn Pettis (5/10/2012)
Stefan Krzywicki (5/10/2012)
RBarryYoung (5/10/2012)
Koen Verbeeck (5/10/2012)
Stefan Krzywicki (5/10/2012)
Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through a list of the Oracle tables obtained with a query against all_tables. It is slow, it is tedious, but it is more reliable. I worked out the permissions, needed to either encrypt the package with a password instead of a user key or set up a proxy, neither of which I'd done before, so at least I'm learning new things!
Never encrypt with user key in SSIS, it only gives troubles ahead, as you probably figured out by now 😀
My experience has been that "Don't Save Sensitive.." and relying on Trusted Connections is by far the easiest way to go.
So where do you get the passwords from for connections then? I don't know about Trusted Connections.
Trusted connections, also known as windows users/qroups. SQL Trusts Windows to authenticate the user.
Ah, yeah that's not going to work in this case.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 10, 2012 at 1:13 pm
GilaMonster (5/10/2012)
Barry!!!!!!Welcome back. How ya been?
+1
Hopefully very good.
May 10, 2012 at 1:18 pm
Brandie Tarvin (5/10/2012)
Apparently, I just made one of the help desk guys very happy. He passed on a user problem with an Access db that has become unwieldy asking for solutions. My response was: "We don't support Access. If this database is necessary to the users to do their jobs, they can submit a project to have the db upgraded to a scalable, backed up, and monitored solution."I thought he was going to throw a fit. Instead, he digitally "hugged" me because I apparently told the users exactly what he's been trying to explain to them for months.
Huh. I guess DBAs and Help Desk Geeks can get along after all. 😉
We haven't supported Access for 10 years, but they keep handing it out to the users.
So we are our own worst enemies arond here some days.
May 10, 2012 at 1:43 pm
GilaMonster (5/10/2012)
Barry!!!!!!Welcome back. How ya been?
Hey Gail, et. all.. 🙂 Life's been crazy, but slowly getting better.
So what'd I miss?
😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 10, 2012 at 1:58 pm
Someone brought a baby in to work! I want to go to Germany and see my grandson! :exclamationmark:
May 10, 2012 at 2:17 pm
Stefan Krzywicki (5/10/2012)
RBarryYoung (5/10/2012)
Koen Verbeeck (5/10/2012)
Stefan Krzywicki (5/10/2012)
Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through a list of the Oracle tables obtained with a query against all_tables. It is slow, it is tedious, but it is more reliable. I worked out the permissions, needed to either encrypt the package with a password instead of a user key or set up a proxy, neither of which I'd done before, so at least I'm learning new things!
Never encrypt with user key in SSIS, it only gives troubles ahead, as you probably figured out by now 😀
My experience has been that "Don't Save Sensitive.." and relying on Trusted Connections is by far the easiest way to go.
So where do you get the passwords from for connections then? I don't know about Trusted Connections.
I prefer Windows Authentication. If it's not possible, I use DontSaveSensitive and store the password in a package configuration inside a SQL Server table.
That way I can trust SQL Server to do the security.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 10, 2012 at 2:37 pm
Lynn Pettis (5/10/2012)
Anyone with good to excellent knowledge of Reporting Services, your input here would be much appreciated. I think it would be a better choice than what the OP is suggesting.
I wouldn't even claim good knowledge of RS, but added my 2 cents worth.
I too think RS would be a good solution, especially to select (not type in) the parameters.
May 10, 2012 at 2:42 pm
Greg Edwards-268690 (5/10/2012)
Lynn Pettis (5/10/2012)
Anyone with good to excellent knowledge of Reporting Services, your input here would be much appreciated. I think it would be a better choice than what the OP is suggesting.I wouldn't even claim good knowledge of RS, but added my 2 cents worth.
I too think RS would be a good solution, especially to select (not type in) the parameters.
OP thinks RS would force the users to adapt to him rather than him adapt to the users. Also, added additional requirements not previously mentioned in original post or mock-up.
May 10, 2012 at 3:11 pm
Lynn Pettis (5/9/2012)
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.Wow! Working with Oracle really did put the pinch on you. 😀
Actually, it is he-who-is-without-clues that put the pinch on me. :w00t:
Trying a different tact to see if we can get him to finally give us what we need to help him.
Hi, Lynn.
Do we need to do an intervention?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 10, 2012 at 3:16 pm
The Dixie Flatline (5/10/2012)
Lynn Pettis (5/9/2012)
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.Wow! Working with Oracle really did put the pinch on you. 😀
Actually, it is he-who-is-without-clues that put the pinch on me. :w00t:
Trying a different tact to see if we can get him to finally give us what we need to help him.
Hi, Lynn.
Do we need to do an intervention?
Actually, no. The latest piling on of he-who-is-without-clues was enough. I posted my various versions of the solution to my hypothetical problem that I asked him to solve, and have walked away. Took a peek though and it doesn't look like he's come back.
I had expected his latest post asking for help to improve the performance of his stored procedure, and was hoping he may have finally seen the light. I was hoping by taking a different tact, it may even help. Guess we'll never know.
May 10, 2012 at 3:53 pm
Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.
Liked Eugene's dbo.p_ShowMeWhenICanGoHome though. Yeah, it was a pile-on, but I learned something when I saw RAISERROR (@msg,10,1) WITH NOWAIT and actually ran the SP.
May 10, 2012 at 3:56 pm
Jan Van der Eecken (5/10/2012)
Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.Liked Eugene's dbo.p_ShowMeWhenICanGoHome though. Yeah, it was a pile-on, but I learned something when I saw RAISERROR (@msg,10,1) WITH NOWAIT and actually ran the SP.
Only problem is he won't have learned anything. So much that could have been done weeks ago had he just listened, read, and posted what was requested.
May 10, 2012 at 3:59 pm
Lynn Pettis (5/10/2012)
Someone brought a baby in to work! I want to go to Germany and see my grandson! :exclamationmark:
Don't say you start behaving like these hysterical women who go all berserk when one of the other female colleagues bring in their newborn? TsTsTs... :w00t:
May 10, 2012 at 4:02 pm
Lynn Pettis (5/10/2012)
Jan Van der Eecken (5/10/2012)
Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.Liked Eugene's dbo.p_ShowMeWhenICanGoHome though. Yeah, it was a pile-on, but I learned something when I saw RAISERROR (@msg,10,1) WITH NOWAIT and actually ran the SP.
Only problem is he won't have learned anything. So much that could have been done weeks ago had he just listened, read, and posted what was requested.
Sure, but one can only help so far. Slowly I'm starting to wonder whether he's not just a Troll who's trying to provoke all kinds of not so funny reactions from The Experts.
Viewing 15 posts - 36,031 through 36,045 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply