question

jswayne avatar image
jswayne asked

Setting the SQLSetEnvAttr in an SSIS package

How do you set "SQLSetEnvAttr" in an SSIS package. The ODBC driver isn't compatible with the new OLE DB version 3.# I have browsed through two days of web sites, looking for examples of setting the the "ODBC_AllocEnvironment" to version 2 within the SSIS package. Thanks for any help provided.
ssisodbcsettings
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

can you give us some more information please - SQL Server version, OS version, 32/64 bit, what data source etc etc ?
0 Likes 0 ·
I think the ODBC version is set by the OS?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.