Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.