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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Fatherjack avatar image Fatherjack ♦♦ commented ·
can you give us some more information please - SQL Server version, OS version, 32/64 bit, what data source etc etc ?
0 Likes 0 ·
Daniel Ross avatar image Daniel Ross commented ·
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.