Self Executing DTS or Export?

I have a bunch of records from several tables that I need to bring over to another company's database. The problem is the other company does not have a DBA available and the users are not too familiar with SQL Server. Is there a way to create a DTS package or some other executable that the end users can just execute on their desktops that will insert these records? I am looking for something that will allow them to enter in authentication credentials and server details (host name, etc ..) and then the package will do the rest.

  I could always create a winforms application to do this but I was hoping to find something that was a bit easier to put together. I didn't know if SQL Server 2005 provided something like this. Thanks.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
dtsrun.exe comes with sql server to run a dts package...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.