Home Forums SQL Server 2005 SQL Server 2005 Integration Services Copy Tables in SSIS 2005 RE: Copy Tables in SSIS 2005

  • February 13, 2014 at 12:29 am

    #1688617

    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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.