Ok, thanks for the suggestions!

Thanks - the problem for me is, I have my development machine, and the production server - that's it....

Do you see any problem with my continuing to create SSIS packages...

mtassin (12/17/2012)

---

1. Generate a config file and put the username and password within it. From the SSIS menu in BIDS.

2. Why not add the SSIS package to the SQL...

Robert - I've read that solution in a few places - but unless I'm not understanding, this would require me to be able to open the package, and change those...