Post reply

SQL 2005 Transactional Replication

  • August 11, 2008 at 11:44 am

    #382219

    Can anyone give me direction on filtering data in a transactional publication using an SSIS package? I have used SSIS in other apps but not for this purpose. I have very large tables that I am replicating and can only filter by a value in that table. I need to filter tables using a WHERE clause on joined tables. Any help would be appreciated.

  • August 11, 2008 at 2:17 pm

    #856366

    First a word of caution:

    Transactional replication with horizontal partitions can cause severe performance problems. Test, test and then test more befor you go into production.

    So to get around the limitation you can create a UDF that does the join and use it in a WHERE clause.

    Good Luck


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply