Good Evening all,
We have an interesting issue.
We are using Access to OLEDB and want to use BulkLoad capabilities and we want to use windows authentication..
However when defining library in Metadata Server using Management Console it always fails because you cant use BULKLOAD and OLEDB Services.
We have been able to build the library using OLEDB engine with BULKLOAD and windows authentication using good old base SAS code techniques
Now we want to register it with Metadata server since management console cant create it, How is that performed? Is there a better way?
There are limitations as indicated in the documentation.
It specifically indicates that BULKLOAD is not supported thru OLEDB Services. However if you direct connect to the data source with provider and information BULKLOAD will work, which we have been able to do using base sas coding using Enteprise Guide. THe problem that we have encountered is that when you use Management Console to create the libref defintion despite multiple configurations on properties tabs SAS OLEDB Services are deployed and we cant find a way to perform the direct connection required to enable BULKLOAD:
What we are truly trying to do is establish a libref using sas management console to a SQLServer 2008 database where the bulkload option is enabled.
If order for this to work we need to somehow have sas managment console create a direct connections through the provider to the SQLServer database and not via OLEDB Services.
One option is to use the generic library template. In this library, you can type in your own libname statement. It still gets registered in metadata as a library, but the syntax is entirely user written.