HI

I want to extract records >50000 from Sybase server to my sqlserver.

1)Which is the best solution for this without impacting the performance?

2) If i have to use a DTS package how do i pass a parameter to
DTS package from .net extract the parameter and use it in a
dynamic query?

3) Can i use BCP from .net?



Any help on this would be useful.



Regards

Subbu


--
Posted via http://dbforums.com

Hi,
You can create a DTS pkg and execute it from C#.
Here is an example.
http://www.sqldev.net/dts/DotNETCookBook.htm
JFB

"reachsubbu" <member37845 (AT) dbforums (DOT) com> wrote