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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Migrating SSIS packages from SQL 2005 server to new SQL 2012 server 1
- Thread starter Luvsql
- Start date
-
1
- #2
jjefferson
Technical User
If you are careful, you should be able to text-edit your .dtsx item and find the <DTS:ConnectionManager> entries, and make adjustments there. I haven't done this myself before, but if you make a copy for safety you should be able to recover if it doesn't work.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question