Link to home
Start Free TrialLog in
Avatar of thecodingflea
thecodingflea

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial