Post reply

How to build in SSIS

  • August 4, 2015 at 7:34 am

    #299381

    I need to fetch data from one SQL server to other SQL Server. One solution is to create linked server and other is to use SSIS. How it can be done using SSIS? any help would be appreciable.

    Thank You!

  • August 4, 2015 at 7:47 am

    #1817113

    You mean Source and destination both are SQL SERVER ?

  • August 4, 2015 at 7:50 am

    #1817114

    sqlinterset (8/4/2015)

    I need to fetch data from one SQL server to other SQL Server. One solution is to create linked server and other is to use SSIS. How it can be done using SSIS? any help would be appreciable.

    Thank You!

    If you have to ask how it can be done in SSIS then that suggests to me that you have a lot of learning to do about SSIS before you can tackle this, more learning than we can teach you here.

    I suggest you take the time to learn how to use SSIS before going any further.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 4, 2015 at 8:02 am

    #1817117

    Yes.

  • August 4, 2015 at 8:02 am

    #1817118

    Can you share some really good articles?

  • August 4, 2015 at 8:31 am

    #1817134

    sqlinterset (8/4/2015)

    Can you share some really good articles?

    I would start with the Stairway Series on SSIS by Andy Leonard.

    http://www.sqlservercentral.com/stairway/72494/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 4, 2015 at 8:39 am

    #1817145

    Start with sttairways

    http://www.sqlservercentral.com/stairway/72494/[/url]

    EDIT:

    too late :hehe:

  • August 4, 2015 at 11:26 am

    #1817250

    I am new to SSIS, so after reading it so far... i need to install business intelligence development studio to build SSIS solution to bring data from One SQL Server to another... is this correct?

    I am using SQL Server 2012

  • August 4, 2015 at 11:45 am

    #1817259

    sqlinterset (8/4/2015)

    I am new to SSIS, so after reading it so far... i need to install business intelligence development studio to build SSIS solution to bring data from One SQL Server to another... is this correct?

    I am using SQL Server 2012

    For 2012 you would use SSDT.

    https://www.microsoft.com/en-us/download/details.aspx?id=36843

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 5, 2015 at 9:49 am

    #1817609

    I build a solution is SSIS data tools. I build control flow and data flow. when i click on individual tasks in control flow (right click and execute) then package runs totally fine and data pulls from one server and inserts into other.

    But when i right click on package in solution explorer and then click execute package then it gives me package validation error as in attached screen shot.

    Any help/

  • August 5, 2015 at 12:08 pm

    #1817657

    Problem is resolved.

  • August 5, 2015 at 12:12 pm

    #1817659

    You should post how you resolved your problem. It could help others in your position.

  • August 5, 2015 at 12:24 pm

    #1817664

    On control task flow where i was creating table, i added drop table if already exist. Also Right clicked on Destination and clicked on Properties and made “validateExternalMetadata” as False. Then problem got solved.

  • August 5, 2015 at 2:23 pm

    #1817717

    We started with:

    sqlinterset (8/4/2015)

    I need to fetch data from one SQL server to other SQL Server. One solution is to create linked server and other is to use SSIS. How it can be done using SSIS? any help would be appreciable.

    Thank You!

    And we end with:

    sqlinterset (8/5/2015)

    On control task flow where i was creating table, i added drop table if already exist. Also Right clicked on Destination and clicked on Properties and made “validateExternalMetadata” as False. Then problem got solved.

    There is a pretty large chasm on that one. It is good to hear you figured out the solution. Knowing more specifically what was needed, might have gotten to that resolution more quickly.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 14 posts - 1 through 13 (of 13 total)

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