I'm trying to save a DTS package i've created in DTS Designer to a Visual Basic File. The DTS package contains a 'Transfer Databases Task' which copies a database from one server to another. This tasks runs fine if i save it to SQL Server, but i need to save to VB

If i try and save it to a VB file i get a DTS Designer Error message "Member Not Found". I can successfully save other types of task to VB. Tried searching BOL and google

All servers running SQL 2000 SP3

Any ideas?

Never seen this error before but you may like to start by reregistering the
DTS dlls as detailed here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

If this does not help and nobody else has seen it then you may want to open
a call to the boys and girls in PSS

--
--

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


"Stuart Hearn" <anonymous (AT) discussions (DOT) microsoft.com> wrote

copies a database from one server to another. This tasks runs fine if i save
it to SQL Server, but i need to save to VB.
searching BOL and google.