can any one plz give some idea about SQL Server Integration Services (SSIS)?

  • here i am having two database and i want to mapp the data related to that tables

  • I think you should explain your setup a little bit more if you want an answer that you can use.

    If I understand you correct, then you have two databases A and B and in them there are some tables Tbl1, Tbl2, Tbl3. They should be syncronized?

    SUGGESTION 1:

    You could use replication instead of SSIS, and depending on a lot of factors you should choose between Snapshot, Transactional or merge replication.

    SUGGESTION 2:

    If you want to you SSIS, then a very easy way is to add two task to your controlflow:

    1) A SQL Task

    2) A data flow task

    Before you do that, then you should add a connection to Database A and Database B.

    The SQL Task could empty all rows in the destination table.

    The dataflow task you add a source --> Choose the table in the source --> add a destination and drag the line between source and destination.. Do some minor setup in the destination and it is running.

    SUGGESTION 3:

    Also use SSIS, but only have a data flow task, where you have a source and then you choose the transformation Slowly changing dimensions and configure that.

    BUT BUT BUT!! THere are many other ways to do it, and it really depends on what you want to achieve.

    Soren

  • in databse 1st databes A I AM HAVING A COLUMN A

    TABLE 1 SER1

    WHICH IS HAVING COLUMN S LIKE COL1,COLS2 ,COL3

    FROM THIS TABLE I WANT TO TRANSFER DATA OF COLS2 TO 2ND DATABASE

    TABLE 1 SERT

    WHICH IS HAVING COLUMN S LIKE COLL1,COLS2 ,COLL3

    HOW TO CREATE JOB FOR THIS

  • sivag (8/3/2012)


    in databse 1st databes A I AM HAVING A COLUMN A

    TABLE 1 SER1

    WHICH IS HAVING COLUMN S LIKE COL1,COLS2 ,COL3

    FROM THIS TABLE I WANT TO TRANSFER DATA OF COLS2 TO 2ND DATABASE

    TABLE 1 SERT

    WHICH IS HAVING COLUMN S LIKE COLL1,COLS2 ,COLL3

    HOW TO CREATE JOB FOR THIS

    Typing in caps is like shouting. Nobody likes that.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • sorry

  • sivag (8/3/2012)


    sorry

    No problem. Take a look at the import and export wizard to get you started.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • ya i just tried that import data and export data plz tell how to tranfer datas in database a table 1 column

    cols2 to database b table 1 column cols2 one by one data using jobs in sqlserver

  • plz give some idea about jobs in sqlserver

  • When you run the import export wizard, you have the option at the end to save the package. Do that.

    Then follow these steps:

    SQL Server Agent Jobs for Packages

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • here i just opened job and i made a right click the i found new job i just selected that than after that how i can call the source data can any one just tell me

  • sivag (8/3/2012)


    here i just opened job and i made a right click the i found new job i just selected that than after that how i can call the source data can any one just tell me

    I think it's best you search the net a while for tutorials and SSIS books to get you started.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • If these are two databases on the same instance you can just run this to transfer data accross.

    INSERT INTO DatabaseTarget..TableTarget (COL1, COL2)

    SELECT COL1, COL2 FROM DatabaseSource..TableSource

    That is the concept. There is more learning required to automate it.

Viewing 12 posts - 1 through 11 (of 11 total)

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