http://www.sqlservercentral.com/blogs/jeffrey_yao/2005/09/08/one-issue-about-sql-2000-bol-/

Printed 2014/09/16 11:46PM

one issue about SQL 2000 BOL

By Jeffrey Yao, 2005/09/08

This is my first post, congrats to myself. :-)

DTS Connection object does not list "UseTrustedConnection" property

I am working on a DTS package where I'd like to reset the connection authentication from Windows to SQL Server with user id and password. I tried to search the properties under Connection object, but I simply cannot find such a property, but when search the property category, I find the property exists and it applies to Connection and Connection2 object.

Actually I have noticed some other small issues before but I just forget at this time, I will try to find them out and post it here. They are about the incorrect column data type definitions for some system tables.

Of course, my BOL is the latest one.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.