So you're moving data between Sybase and SQL Server using DTS through .Net
If you can execute the same package from the same PC using VB then it does
not sound like DTS
Because your other DBMS is Sybase you will need the drivers for it on the PC
you fire the package on.
..Net will need to wrap DTS in COM Interop.
Things to try
Build a super simple package (SQL Server --> SQL Server)
Does that work through .Net ?
--
----------------------------
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
"Jason Chen" <icq_power (AT) msn (DOT) com> wrote
Quote:
hi, Allan, thank u at first.
but my question is yet not solved. I have already added
the references dtspkg.dll and dtspump.dll to my project
but it works as the same as before, it still gives a
tip "A dll is absent". why? Note: my DBMS is Sybase.
|
Re: Error is still existed -
08-05-2003
, 01:32 AM
Linear Mode
