Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Wednesday, September 08, 2010

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

Build the right apps the right way with powerful development tools.
Visual Studio 2010. Learn more...

Add Review and Rate the listing.

Home > Search > Applications > SQL > DTS
SQL Server 2000 DTS Authentication with UDL Files        
Total Hits: 219  |  Today: 0 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

Many of the objects (Execute SQL Tasks, ActiveX Scripts, Connection Objects, etc.) in SQL Server 2000 Data Transformation Services (DTS) Packages require authentication to SQL Server when extracting, transforming and loading data. It is quick and easy to just add your SQL Server user name and password. Some even say 'better yet I know the sa password, so I will add it'. Wrong! In the short term embedding the user name and password may be quick and easy, but in the long term when passwords need to be changed or employees leave the organization, the password management problem quickly becomes unwieldy.

If you would like to add your review of the above resource please complete the form below. All reviews are screened before they are posted on the website. Any malicious, vulgar, or unsubstantiated reviews will be removed.

Review Title:   *
Your Full Name:   *
Email Address:  
Email address will not be displayed with review.
Your Comments: *
Your Rating: *
   

<< Back to listing

DevASP.Net - Disclaimer - Privacy
© 2002-2010 DevASP.net