Post reply

Data Transformation

  • February 13, 2009 at 3:06 pm

    #128741

    Hi,

    I have columns in different tables in one sqlserver database,i have to transfer these columns data to someother database table in sql server .Every time updation has to go from one database to other database.Both databases are from sqlserver.

    For, this i have to create a ssis package.How can i build an SSIS Package(what components can i use?).

    Thanks,

    naidusql.

  • February 23, 2009 at 9:25 am

    #948696

    First design what you want to do from a theoretical approach, then figure out what tools you need to do it.

    The most obvious components are going to be data flow task(s) containing OLE DB Source from SQL Server to OLE DB Source for SQL Server destination. There's an infinite list of things that could happen in the middle.


    Rick Todd

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

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