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.