New to DTS

[azeke]

I've worked mostly with stored procedures with parameters that read data from a 'loader DB table' to load data into the application tables of my DB. One problem I'm having is referencing a procedure or table thru a linked server. The connection acts flaky (meaning it drops sometimes for no apparent reason). I'd like to try using DTS load data. I've started by adding the two servers as connections. I'm not sure what the next step should be. I appreciate any help offered.

 

[foxdev]

I would recommend using the data Import (or Export, depending on which side you start from) Wizard, then save it as a DTS package. You can then edit the package, and it will give you a headstart.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[azeke]

Using the wizard is a great start. I'm still having trouble using parameters in my query. I need to pass the package a value in which the query will filter which records to select. ???