SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

one issue about SQL 2000 BOL

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.


No comments.

Leave a Comment

Please register or log in to leave a comment.