I exported the 3 packages that were setup in SQL 2005 and imported them into my new SQL 2012 server. The datasources on the package are still referencing the old server but I'm unable to edit them within the job in sql server. I don't have Visual Studio. Is that the only way to make a data source modification?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.