Other Tools to Develop SSIS Package

  • Good Morning Guys,

    I just what tools do i need so i can create a simple SSIS package. i currently have a Fully licensed SQL Server 2012 but i don't have a Visual Studio Installed on my machine. is there a substitute tool that i can use so i can create my SSIS package with only my SQL Server 2012? any help from you guys is very much appreciated.

    Best Regards,

    Noel Isip

  • Do you have SQL Server Data Tools? It's not a full version of Visual Studio. That's enough to do SSIS.

  • pietlinden (12/29/2015)


    Do you have SQL Server Data Tools? It's not a full version of Visual Studio. That's enough to do SSIS.

    That's not "enough" for SSIS. That is EXACTLY what you need!



    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]

  • At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Eric M Russell (12/29/2015)


    At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

    Eric, if you're gonna go that route, at least recommend Notepad++

    😀

    It's true, you can build packages with any text editor, but it's more work than you're looking for. 🙂



    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]

  • Alvin Ramard (12/29/2015)


    Eric M Russell (12/29/2015)


    At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

    Eric, if you're gonna go that route, at least recommend Notepad++

    😀

    It's true, you can build packages with any text editor, but it's more work than you're looking for. 🙂

    Let's not turn this into a religious debate. Both tools can get the job done. :satisfied:

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Stylez (12/29/2015)


    Good Morning Guys,

    ...is there a substitute tool that i can use so i can create my SSIS package with only my SQL Server 2012?

    Depending on what you are trying to do you can build packages in SQL Server Management Studio too. E.g. you can Right-Click a database, go to Tasks then select import or export, select stuff to import/export then save your work as an SSIS package. You can also create SSIS packages under Management >Maintenance Plans.

    Again, it depends what you want to do.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • Much Thanks to all you guys, i have downloaded the newest version of SSDT for Visual Studio 2015. i will try to create a sample package and see what features it has to facilitate in creating the SSIS Package i need. Again Much Thanks to all you guys for providing me with all the possible answers i would need

    Best Regards,

    Noel Isip

  • This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

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