Hi Kurt,

It's much easier to manage stored procedures than DTS packages. If you've a choice stick with sproc's. If you've remote access to shop's SQL Servers, you can create sproc's remotely using Query Analyzer. Or you can send sproc's script to the remote site and ask them to run it from QA.

>
>Well i mean what's the best choise to make : 1° work with a dts or 2° work with a stored procedure for transfering information from one sql server to another.
>
>And once i've made a dts or stored procedure how do i get it the fastest way installed in 150 shops ? I can't install the package on the main server due to practical reason. So i have to install it in every shop. Can i make an install file for a dts/stored procedure ?
>