• jevogelsong (2/11/2014)


    Hello,

    I have a SQL server using a scheduled job to call a SSIS package which copies tables from one server to another. I was asked to add a few more tables to the job. So far I have opened the solution and under Control Flow there is a Transfer SQL Server Objects task. I have edited this and under tables to copy I have added the new tables and saved the solution. This has not brought over the new tables. Is there anything else I should be doing?

    Thanks,

    Joe

    Have you deployed the package to the location which the SQL Agent job is picking it up from?