Home Forums SQL Server 2005 SQL Server 2005 Integration Services Transfer Data from one database table to Another database table RE: Transfer Data from one database table to Another database table

  • September 28, 2012 at 12:40 am

    #1543205

    Phil Parkin (9/27/2012)

    Have a look here and see how you get on. It does something similar to what you require.

    Thanks Phil...

    But we need to transfer the data from source to target directly without using staging table.

    In the given URL, they have loaded to staging table and then they loaded to target table.

    I have tried without using staging table, record in source get loaded to target.

    Again i ran the package, the entire records got loaded into target without considering the MaxID

    Regards

    SqlStud