ssis - StoredProcedures and Functions transferred with different schema name while using Transfer SQL Server Objects task -
i'm trying move sql server objects i.e.,tables,views,stored procedures,user defined functions 1 database using transfer sql server objects task in ssis.
tables,views transferred destination database same schema name in source database . however,some of stored procedures , user defined functions changed 1 of schemas in destination database upon completing transfer.
any appreciated.
thanks.