I have Spoon and I am transferring Data through MySQL to SQL server on daily basis.
I want to schedule Spoon file(.ktr and .kjb) ,How to schedule that file.
I Created a Package IN SSRS and tried it scheduling through SQL SERVER AGENT JOB but its giving an Error,manually data is getting transfer in the SQL server tables,but I need it to schedule in morning 4 AM.
When i am making scheduling in SQL AGENT its showing error in job history that "Job Failed Job was Invoked by USER SA,Next step was step 2".
I want to schedule the job so that in every morning I can Transfer data from Mysql to SQL Server.