Answered by:
SSIS transfer job task error

Question
-
Hi,
i did a simple transfer job task with ssis .
1- sql server 2008 to 2012 to tranfert job
2- use ssis on 2012 to do the package
3- connection are good
4- user is ssys admin and db_ssisadmin, db_ssisoperator
5- when i execute the package i got this error Erreur : 0xC002F325 à Tâche de transfert de travaux, Tâche de transfert de travaux: L'exécution a échoué avec l'erreur suivante : « Une exception s'est produite lors du transfert du travail « dbname». ».
Any idea?
Tuesday, August 18, 2015 2:13 PM
Answers
-
DAMN!!
Ssis services on sql 2012 was at manual and stopped!!
Thanks
- Marked as answer by pbellerive Tuesday, August 18, 2015 6:13 PM
Tuesday, August 18, 2015 6:13 PM
All replies
-
Check your DB name on both servers is the same.
A Fan of SSIS, SSRS and SSAS
Tuesday, August 18, 2015 2:17 PM -
"to Transfer Jobs Task, Transfer Jobs Task: The execution failed with the following error: "An exception occurred during the transfer of labor" dbname ". "."
Please post in English.
There was an error in the transfer of the database. Nice and ambiguous, I would look at the executing servers audit logs, and see if there's any further clue there.
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question. Enjoyed my post? Hit the up arrow (left)
Really enjoyed it? See my profile!
My Tech Net Articles.Tuesday, August 18, 2015 2:24 PM -
The transfert job task is not for database but for scheduled job.
I try to transfert all my schelude job to the new server. SSIS have the transfert job task.
Do you have a fix to my problem or any other way to do that?
Tuesday, August 18, 2015 2:46 PM -
DAMN!!
Ssis services on sql 2012 was at manual and stopped!!
Thanks
- Marked as answer by pbellerive Tuesday, August 18, 2015 6:13 PM
Tuesday, August 18, 2015 6:13 PM