alexandre.jobin (4/7/2014)
sqlbuddy123 (4/4/2014)
I don't rely on SSIS transfer Object\Login task as it gives lot of issues.alright, i will do it manually. Maybe it should be another topic but what kind of issues can you have with SSIS? Are you talking about issues to transfert objects/logins with ssis or the issues is with ssis in general?
we are planning to use ssis for night jobs. What should i know about ssis? is it time consuming or i can rely on it to be maintenance free?
SSIS is a pretty good tool when used for ETL tasks\jobs. You can definitely make a good use of it.
The only issue is with the Transfer Object\Login tasks which doesn't work as expected.
--
SQLBuddy