Home Forums SQL Server 2008 SQL Server 2008 - General SSIS Transfer SQL Server Object Task RE: SSIS Transfer SQL Server Object Task
Jared
SSC Guru
Points: 61793
More actions
July 19, 2012 at 3:08 pm
#1515201
It seems like the user in the old database had a default schema of DMUSER, but in the new (destination) the user has a default of dbo. Then, the SSIS task is creating the sp's in the context of the user maybe?
JaredCE - Microsoft