I'm designing a custom task that very similar to the standart
transformation task. I need to use the connections in design mode have
an able to run a query upon them, so the user can select database,
table and map a data used for pumping process. The problem is, that i
cannot get a password property from Connection object - it always
comes as Null.


--
Posted via http://dbforums.com

Is this your problem

Why can't I read the Password property from a DTS Connection?
(http://www.sqldts.com/default.aspx?209)

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org




"JrMobile" <member44111 (AT) dbforums (DOT) com> wrote

Yes, this is it. But there is no resolution.


--
Posted via http://dbforums.com

What should i do to resolve that and make it redable while using SQL2000



Originally posted by Allan Mitchell




--
Posted via http://dbforums.com

I don't know that you can. It would seem like a huge security hole, being
able to read a password from a connection. What if the package designer
used "SA" ? If you could retrieve the pasword then the world is your
oyster.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"JrMobile" <member44111 (AT) dbforums (DOT) com> wrote

So, the only way is to use an ole-db methods and only C++ to develope
this kind of custom task, that able to maniulate its own connections.
Am i right?


--
Posted via http://dbforums.com