Post reply

Copy flat file source settings to new SSIS package?

  • July 9, 2009 at 10:42 am

    #136093

    Hello,

    Is it possible to copy a flat file source definition - including the field-by-field mappings and data type definitions - from one SSIS package to another? I have such a flat file source with dozens and dozens of fields in one SSIS package and I would like not to have to re-do them all in a new version that I am creating.

    Thanks in advance for any help. Let me know if you need any more details about the issue.

    Sincerely,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • July 9, 2009 at 11:39 am

    #1022573

    You can copy the connection manager from one package to another. I believe than should give you what you wanr.


    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]

  • July 9, 2009 at 11:49 am

    #1022577

    Alvin Ramard (7/9/2009)

    You can copy the connection manager from one package to another. I believe than should give you what you wanr.

    Thanks. Do you mean you can right-click the connection manager and copy it, then paste it in Connection manager section of the other SSIS package design screen?

    Thanks again,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • July 9, 2009 at 12:02 pm

    #1022584

    webrunner (7/9/2009)

    Alvin Ramard (7/9/2009)

    You can copy the connection manager from one package to another. I believe than should give you what you wanr.

    Thanks. Do you mean you can right-click the connection manager and copy it, then paste it in Connection manager section of the other SSIS package design screen?

    Thanks again,

    webrunner

    That is what I meant.


    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]

  • July 9, 2009 at 12:12 pm

    #1022589

    Alvin Ramard (7/9/2009)

    webrunner (7/9/2009)

    Alvin Ramard (7/9/2009)

    You can copy the connection manager from one package to another. I believe than should give you what you wanr.

    Thanks. Do you mean you can right-click the connection manager and copy it, then paste it in Connection manager section of the other SSIS package design screen?

    Thanks again,

    webrunner

    That is what I meant.

    Great, thanks. I can't believe it's that easy.

    Sincerely,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • July 9, 2009 at 12:30 pm

    #1022600

    Yep, pretty easy, and you're welcome.


    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]

  • July 9, 2009 at 6:19 pm

    #1022807

    If you are starting fresh, you could just copy the package and rename it and then take out anything you don't need..

    CEWII

  • July 10, 2009 at 7:58 am

    #1023035

    Elliott W (7/9/2009)

    If you are starting fresh, you could just copy the package and rename it and then take out anything you don't need..

    CEWII

    Thanks. What if I started with a whole solution folder on my local desktop and want to transfer it to a test server that doesn't have Business Intelligence Development Studio on it? Is there a way to copy the whole folder, or do I not need to?

    My problem is that when I try to deploy the package, it throws errors when I run it (trying to connect to my local desktop connection manager).

    Thanks again for any help.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

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

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