I ran into this problem today after creating a dataflow which wrote data to a temporary table.
|4580||4460||DBS-070401||14/06/2013 17:19|||Data flow DF_XXXX|Loader Query_XXXX|
|4580||4460||DBS-070401||14/06/2013 17:19||ODBC data source <SQLSERVER\INSTANCE> error message for operation <SQLBindParameter>: <[Microsoft][ODBC SQL Server Driver]Optional feature not implemented>.|
The temporary table had a date datatype on it and kept returning the following error when trying to create the table in the SQL Server 2008 R2 SP2 database.
Why this issue:
I did not have the latest version of SQL Server Native client installed. In my case above on my Win 2008 R2 server I only had the default one installed (SQL Server 6.01.7601.17514 SQLSRV32.DLL) which I think is pre-2008 and pre-2008 SQL Servers did not have a date data type.
So I did this:
Downloaded the x64 version of Microsoft® SQL Server® 2012 Native Client [sqlncli] which can be found here. Installed this and then problem solved even though I use SQL Server 2008 R2.