Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Updating Data Warehouse

    I just need to understand how to automatically schedule (every day for example) the integration services process

  • RE: Updating Data Warehouse

    Oh sound's great! I just added a OLE DB comand with TRUNCATE TABLE between DB.Table1 and DW.Table1 and it work 😛
    Thanks 😉

  • RE: Updating Data Warehouse

    so how can i do this? stored procedure?
    If yes what's the best way and code for do that?
    Thank you and apologize for these questions but...

  • RE: Updating Data Warehouse

    Does your source table have a primary key? Yes, Col1 for example it's primary key
    Does it have DateCreated and DateModified columns? No

  • RE: Updating Data Warehouse

    I Have:
    SOURCE DB TABLE1
    Col1      Col2     Col3  Col4    Col5
    Test      Test      Test  Test     Test

    I create a DW with an integration Services process and now i have
    DW.TABLE1
    Col1      Col2     Col3

Viewing 5 posts - 1 through 6 (of 6 total)