I'm working on an SSIS issue which appears to disappear if you put "set ANSI_WARNINGS OFF" at the beginning of the SQL query. I may end up having to add that to every one of my SSIS packages.I would rather just change the connection string to set ANSI_WARNINGS. Can I do that? I'm using an OLEDB connection and SQL Server Native Client. What's the connection string property name I should use?
Based upon the following page, it appears you can do it. The statement that made me think that was "OLE DB and ODBC applications can specify the option settings that are in effect at connection time by specifying option settings in connection strings. The option settings are applicable only to the current connection session."http://msdn.microsoft.com/en-us/library/ms175088(SQL.90).aspx
View Complete Post