dbTalk Databases Forums  

Dynamic Property Task to set blank password for connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Dynamic Property Task to set blank password for connection in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ajit
 
Posts: n/a

Default Dynamic Property Task to set blank password for connection - 12-02-2003 , 04:46 AM






Hi
I have an 'Execute Package' task for which I need to make server name, username and password configurable.
I have INI file from where I wish to configure above properties. My problem is, I am able to configure server name and username from INI file but I can not configure password. The server password is blank and dynamic property task does not set up blank password

Any idea as to how to resolve this problem

Thanks
Aji


Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default Dynamic Property Task to set blank password for connection - 12-03-2003 , 01:09 AM






Hi Ajit,

Firstly its not a good idea to have blank passwords.

The Dynamic Property task will throw an error when the
VALUE for any KEY (which its using) in the INI file is
BLANK.

Cheers,
Sanka

----Original Message-----
Quote:
Hi,
I have an 'Execute Package' task for which I need to make
server name, username and password configurable.
I have INI file from where I wish to configure above
properties. My problem is, I am able to configure server
name and username from INI file but I can not configure
password. The server password is blank and dynamic
property task does not set up blank password.
Quote:
Any idea as to how to resolve this problem?

Thanks,
Ajit

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.