tag:blogger.com,1999:blog-12142612.comments2023-05-22T10:59:13.009+01:00Thoughts of a Freelance Dolphin TrainerStevehttp://www.blogger.com/profile/11840051314226786933noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-12142612.post-37269298785466434872011-05-25T12:11:13.419+01:002011-05-25T12:11:13.419+01:00thxthxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-25991342626370001852009-12-21T16:01:10.317+00:002009-12-21T16:01:10.317+00:00I had a similar problem but it came down to using ...I had a similar problem but it came down to using dynamic sets in 2008markhttps://www.blogger.com/profile/14641141090656343177noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-55576105627146405352009-07-07T13:11:58.601+01:002009-07-07T13:11:58.601+01:00I think there's a comment further up that talk...I think there's a comment further up that talks about the Oracle driver problems. They've gone in to more detail here... http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=11Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-1294535649093044652009-07-06T22:09:33.624+01:002009-07-06T22:09:33.624+01:00Steve: Thanks for this blog.. I got it working us...Steve: Thanks for this blog.. I got it working using this method..<br />http://forums.oracle.com/forums/message.jspa?messageID=2583801#2583801<br /><br />Question now.. do you know if Oracle fixed what they needed to do a workaround in 10g client in the 11g client?DChttps://www.blogger.com/profile/15557506842666259691noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-30623787174382760162009-03-10T18:18:00.000+00:002009-03-10T18:18:00.000+00:00No problem. How are you doing anywayNo problem. How are you doing anywayStevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-54089797989752962202009-03-10T17:56:00.000+00:002009-03-10T17:56:00.000+00:00Hi Steve,Nice article mate. Should help me sort ou...Hi Steve,<BR/><BR/>Nice article mate. Should help me sort out our server configuration.<BR/><BR/>Cheers,<BR/>Adam.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-80742581854420997702009-02-12T15:51:00.000+00:002009-02-12T15:51:00.000+00:00The album came out either this week or last but is...The album came out either this week or last but isn't available from all reputable retailers yet (that I can be bothered to go to anyway).<BR/>I hear Europe are releasing a "best of" album you might be interested in, we all know how you like a power ballad :)Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-53579743949744509052009-02-12T15:22:00.000+00:002009-02-12T15:22:00.000+00:00Is the rest of the album is rubbish then?Is the rest of the album is rubbish then?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-9522949417386870472009-01-23T09:53:00.000+00:002009-01-23T09:53:00.000+00:00I haven’t explicitly looked into this issue with S...I haven’t explicitly looked into this issue with SQL Server 2008 but I can’t imagine Microsoft have changed their stance on developing 64 bit providers for Oracle. If you have all of the tools installed on your 64 bit system have a look in the Program Files and Program Files x86 directories and you should be able to determine which applications are 32 or 64 bit then use the logic in the blog post to go from there.Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-68310140935349698612009-01-22T22:03:00.000+00:002009-01-22T22:03:00.000+00:00I am running into issues with Oracle provider in 6...I am running into issues with Oracle provider in 64 bit with SQL2008 SSIS.<BR/><BR/>Do the workaround apply to SQL2008 also?pranmalahttps://www.blogger.com/profile/00704964630036303555noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-71679469472823860002008-12-29T17:32:00.000+00:002008-12-29T17:32:00.000+00:00Hi, Steve. If you are still interested in unit tes...Hi, Steve. If you are still interested in unit testing SSIS, you might want to take a look at www.codeplex.com/ssisunit. It's an open sourced unit testing framework for SSIS that I've developed, and I'd like to hear any feedback that you have on it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-81165877229718995712008-11-10T15:32:00.000+00:002008-11-10T15:32:00.000+00:00Good post.Good post.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-71840389352265874132008-09-29T15:19:00.000+01:002008-09-29T15:19:00.000+01:00I used the xml configuration file to separate my e...I used the xml configuration file to separate my environments. It has to be the first config file that gets read. For me it only has the SQL Server where the [ssis configurations] table is but you could store all of your directory info too. I had a hard time with the xml security "feature" not letting me share my xml configuration file with other user accounts like SQLDevJobSvc, or SQLQAJobSvc or SQLProdJobSvc. I did briefly use EncryptSensitiveWithPassword in the package to allow the sharing of the xml configuration file with other user accounts, but creating a password that is hardcoded in a job just seems wrong. Then it dawned on me that if the xml configuration file doesn't know who created it then it wouldn't know who to keep out (que the singing angels).<BR/>Remove the following xml attributes and any package can run as any user and read any xml config file written by anyone:<BR/>GeneratedBy=<BR/>GeneratedFromPackageName=<BR/>GeneratedFromPackageID=<BR/>...You seem too smart to store sensitive (user/pwd) information in a file, but just in case I'll include the blurb we use in our office:<BR/>"If sensitive information must be stored, then XML File configuration cannot be used<BR/>due to security. (And you need to rethink what the heck you are doing)"Unknownhttps://www.blogger.com/profile/08280902008269827226noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-56848397303151449322008-06-25T00:42:00.000+01:002008-06-25T00:42:00.000+01:00This was freaking brilliant! We never would have ...This was freaking brilliant! We never would have figured this out on our own (and we're pretty smart if we do say so ourselves). We were dealing with a 64 bit server and everything worked fine using oracle except SSIS through visual studio. Great job writing it up as well. Very well thought out. Much obliged!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-56861071938227169502008-05-14T01:47:00.000+01:002008-05-14T01:47:00.000+01:00great album :)great album :)agent defiancehttps://www.blogger.com/profile/12775792074178814022noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-26566155785904000202008-04-23T10:27:00.000+01:002008-04-23T10:27:00.000+01:00Ta Steve - Old post, but still useful.Jason.Ta Steve - Old post, but still useful.<BR/>Jason.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-37841622457135512202008-04-04T09:27:00.000+01:002008-04-04T09:27:00.000+01:00Laks,The import / Export wizard will be a 32 bit a...Laks,<BR/><BR/>The import / Export wizard will be a 32 bit application I would imagine so you'll need the 32bit oracle provider installed for it to be seen in the list. How that behaves on Itanium though, I'm not sure.....Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-17138258712530216332008-04-02T22:12:00.000+01:002008-04-02T22:12:00.000+01:00SteveI have a SQL Server 2005 installed in a Itani...Steve<BR/><BR/>I have a SQL Server 2005 installed in a Itanium X64 server. I have installed the Oracle 10g Client. I am able to connect to Oracle using Oracle SQL+PLus, but when I try to connect using the Import/Export wizard it does not work. I get an error saying 'Oracle Clients are not installed'. I cannot see the OraOLEDB Oracle driver in the drop down.<BR/>Any suggestions.<BR/>Regards<BR/>LakslaksUKhttps://www.blogger.com/profile/10057546960092629084noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-2667252792167631082008-04-01T07:50:00.000+01:002008-04-01T07:50:00.000+01:00THANK YOU! (and thank you Google)Was hitting the s...THANK YOU! (and thank you Google)<BR/><BR/>Was hitting the same random obscure problem and sure enough, server CPU was AMD 64bit and setting /usepmtimer seemed to have fixed the problem.sihttps://www.blogger.com/profile/01167034405781671770noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-11354550330145279382008-01-05T09:57:00.000+00:002008-01-05T09:57:00.000+00:00Arpan,Install the 32 and 64bit Oracle providers on...Arpan,<BR/><BR/>Install the 32 and 64bit Oracle providers on your server. You are trying to run a 64 bit process when you have only the 32 bit provider on the server. This will work when you run it interactively but fail when running a job.<BR/><BR/>All the information you need is in the post.<BR/><BR/>SteveStevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-80252893931022057212008-01-04T19:55:00.000+00:002008-01-04T19:55:00.000+00:00Steve,I have developed a SSIS package on a 32 bit ...Steve,<BR/>I have developed a SSIS package on a 32 bit machine and then deployed it on to a 64 bit SQL Server which has a 32 bit VS2005 and SSIS. Now when I open the packages on the 64 bit server I can connect to the oracle box the test connection succeeds. But when I try to run the package or under the SQL Server Job it ERRORS out stating that The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.<BR/><BR/>I can execute the package using dtexec but I really want to execute them under a scheduled job.<BR/><BR/>What can I do to execute the package in SQL Job Agent on the 64 bit server.?Unknownhttps://www.blogger.com/profile/09480237974615198145noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-80483912550322851652007-10-19T18:46:00.000+01:002007-10-19T18:46:00.000+01:00Thanks for a very helpful post, Steve. I've taken ...Thanks for a very helpful post, Steve. I've taken your ideas and run with them a little bit:<BR/><BR/>http://www.artisconsulting.com/Blogs/tabid/94/EntryID/5/Default.aspxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12142612.post-55207718941217871332007-07-18T09:10:00.000+01:002007-07-18T09:10:00.000+01:00Are you trying to execute an Oracle stored procedu...Are you trying to execute an Oracle stored procedure with a cursor in or are you trying to execute multiple Oracle procedures with a SQL Server side cursor?Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-12170584803146857182007-07-18T08:48:00.000+01:002007-07-18T08:48:00.000+01:00How do you execute a stored procedure with a ssis ...How do you execute a stored procedure with a ssis / Oracle and Cursor ?wallstreetfishinghttps://www.blogger.com/profile/12977001721634328591noreply@blogger.comtag:blogger.com,1999:blog-12142612.post-1118952655670555942007-05-29T09:28:00.000+01:002007-05-29T09:28:00.000+01:00As a wild stab in the dark, the problem seems to a...As a wild stab in the dark, the problem seems to always stem from how you execute the initial DTS package. What you could try is creating an SSIS package that has a execute DTS package task in there then running that under the different scenarios...<BR/><BR/>If that doesn't do the trick then come back to me and I'll try and dust off some of my SQL 2000 books :)Stevehttps://www.blogger.com/profile/11840051314226786933noreply@blogger.com