Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
man_25
Starting Member
4 Posts |
 Posted - 2006-10-23 : 22:27:01
|
I have a DTS package that has performance issues. It could be the driver (connecting to an Oracle DB) problem. I've heard that there was a way to dynamically select the Oracle driver rather than hard coding it. This enables you to choose other type drivers like native Oracle driver. How can I programmatically do this?  Is it even possible to dynamically select the driver? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-23 : 22:40:24
|
| why don't you just try your DTS with the other driver? There are only a handful of drivers that you can even test - you have maybe 4 choices max. No point in putting too much time into something like this when it really isn't warranted.btw, I think you might be thinking about global variables and dynamic properties. http://www.sqldts.com is a good site for researching these types of things.-ec |
 |
|
|
man_25
Starting Member
4 Posts |
Posted - 2006-10-23 : 23:05:31
|
I'd need a bit of help here - I see only 2 other 'Oracle' driver and those are - - 'Microsoft OLE DB provider for Oracle' &
- 'Oracle provider for OLE DB'
These are the only 2 Oracle drivers right? Currently I am using 'Microsoft ODBC driver for Oracle'. Are these better than the one I'm using now (in terms of performance)?Also I could not find any way to dynamically use these. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-23 : 23:40:20
|
| there is also an Oracle ODBC driver you can use. those would be the 4 that I am familiar with.OLE DB is faster than ODBC, so stick with OLE DB if possible.Don't worry about trying to do this dynamically. Open your DTS package and save it again with a new name (packagename_oracle_oledb or somesuch). edit the newly saved package and configure it to use the ODBC or OLE DB provider you are wanting to test. do this for all of the different providers you want to test and then test them.-ec |
|
|
|
man_25
Starting Member
4 Posts |
Posted - 2006-10-24 : 00:12:52
|
thnkx a lot eyechart!! I'll do just that!  |
|
|
|
|
|
|
Dynamically selecting DB driver?