Post reply

Open SSIS package

  • January 4, 2013 at 9:43 am

    #268910

    Hi All,

    I need to modify an SSIS package. The package is all about getting excel files from ftp and loading the data in sql database. But, all I have is Windows Batch File, Integration Services package and Integration Services Configuration files. I don't have the solution file. How do I open this and see what is there in the package.

    Please help.

  • January 4, 2013 at 9:45 am

    #1573828

    Create an empty solution and add the .dtsx file to it. Then you'll be able to open it.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • January 4, 2013 at 1:17 pm

    #1573934

    Thanks, Phil. I did that already, It gives me an error 'The configuration file name .... is not valid. Check the configuration file name.

  • January 4, 2013 at 2:38 pm

    #1573970

    pjrpjr7 (1/4/2013)

    Thanks, Phil. I did that already, It gives me an error 'The configuration file name .... is not valid. Check the configuration file name.

    SSIS menu, Package Configurations... something in there is looking for a config file (most likely an XML file) which you don't have locally mapped but the server does. You'll need to get that config file local and remap the package config to it for testing.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

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