+ Reply to Thread
Results 1 to 7 of 7

How do I execute a dtsx file in SQL Management Studio?

  1. How do I execute a dtsx file in SQL Management Studio?

    Hi

    I've created and saved an SSIS package as a dtsx file. It's a simple file
    for exporting data from one MSDE 2000 database to another in the same SQL
    instance.

    I can open the file in design mode but I have know idea how to execute it.
    What am I missing?

    Thanks
    Andrew



  2. Re: How do I execute a dtsx file in SQL Management Studio?

    In the solution explorer ( if you don't see it... ctrl, alt L to open it. )
    Right click on the package name and click execute.
    ... you can also right click on a step and and click execute step.
    hth,
    bob.


    "Andrew Jocelyn" wrote in message
    news:eKsTZw9ZIHA.5160@TK2MSFTNGP05.phx.gbl...
    > Hi
    >
    > I've created and saved an SSIS package as a dtsx file. It's a simple file
    > for exporting data from one MSDE 2000 database to another in the same SQL
    > instance.
    >
    > I can open the file in design mode but I have know idea how to execute it.
    > What am I missing?
    >
    > Thanks
    > Andrew
    >



  3. Re: How do I execute a dtsx file in SQL Management Studio?

    Hi Bob

    When I add a dtsx file to solution explorer it puts it in the Miscellaneous
    folder and there is no right click option to execute and I can't load it
    anyway. I don't get a folder for SSIS so perhaps I don't have the neccesary
    components installed. I installed the Integration Services (which I don't
    think I should need anyway) but it didn't help.

    When I open the file in Server Management Studio I can see the Control Flow,
    Data Flow, Event Handlers and Package Explorer tabs but I don't get the
    option to execute from any step.

    When I try to add a new project I only get a choice of SQL Server Scripts,
    Analysis Services Scripts and SQL Mobile Scripts.

    I found out that I can double click the dtsx file in windows exporer and it
    runs. Obviously I would like to have everything grouped up in a project and
    be able to do everything from there.

    Any ideas?

    Thanks
    Andrew



  4. Re: How do I execute a dtsx file in SQL Management Studio?

    If you have Integration Services installed , normally if you click directly
    on the dtsx file , it will excecute the file.

    You mention , you haven't got a Right Click Option to Execute .You could
    like at opening the package , and then do a "Start Debugging"
    this will actually run through the steps



    --

    Jack Vamvas
    ___________________________________
    Search IT jobs from multiple sources- http://www.ITjobfeed.com




    "Andrew Jocelyn" wrote in message
    news:uWiahaKaIHA.2000@TK2MSFTNGP05.phx.gbl...
    > Hi Bob
    >
    > When I add a dtsx file to solution explorer it puts it in the
    > Miscellaneous folder and there is no right click option to execute and I
    > can't load it anyway. I don't get a folder for SSIS so perhaps I don't
    > have the neccesary components installed. I installed the Integration
    > Services (which I don't think I should need anyway) but it didn't help.
    >
    > When I open the file in Server Management Studio I can see the Control
    > Flow, Data Flow, Event Handlers and Package Explorer tabs but I don't get
    > the option to execute from any step.
    >
    > When I try to add a new project I only get a choice of SQL Server Scripts,
    > Analysis Services Scripts and SQL Mobile Scripts.
    >
    > I found out that I can double click the dtsx file in windows exporer and
    > it runs. Obviously I would like to have everything grouped up in a project
    > and be able to do everything from there.
    >
    > Any ideas?
    >
    > Thanks
    > Andrew
    >




  5. Re: How do I execute a dtsx file in SQL Management Studio?

    Hi Andrew,
    >I don't get a folder for SSIS so perhaps I don't have the neccesary
    >components installed.

    Try creating a new PROJECT...
    when the New Project dialog box appears, select Integration Services
    Project.

    > When I add a dtsx file to solution explorer it puts it in the
    > Miscellaneous folder and there is no right click option to execute and I
    > can't load it anyway.

    .... SSIS Packages should now be in the new project you just created.
    .... go to SSIS Packages
    .......right click on SSIS Packages
    .......click on Add Existing Package
    .......browse to your package and select it.
    at this point is now part of your project.
    you should then be able to right click on the package name and click
    execute...
    or you can click directly on a step and click execute step.

    hth,
    bob.

    >
    > When I open the file in Server Management Studio I can see the Control
    > Flow, Data Flow, Event Handlers and Package Explorer tabs but I don't get
    > the option to execute from any step.
    >
    > When I try to add a new project I only get a choice of SQL Server Scripts,
    > Analysis Services Scripts and SQL Mobile Scripts.
    >
    > I found out that I can double click the dtsx file in windows exporer and
    > it runs. Obviously I would like to have everything grouped up in a project
    > and be able to do everything from there.
    >
    > Any ideas?
    >
    > Thanks
    > Andrew
    >



  6. Re: How do I execute a dtsx file in SQL Management Studio?

    Hi

    I don't have an Integration Services project available when I go to create a
    new project. How do I install the project template?

    Also Debugging is not available when I open the file in Visual Studio 2005
    or BIDS or whatever you call it.

    Are there any other components I need to install? Perhaps I need to
    reinstall SQL server but I can't see why it wouldn't install correctly the
    first time.

    Please advise.
    Thanks
    Andrew



  7. Re: How do I execute a dtsx file in SQL Management Studio?

    Andrew,
    Not sure why you do not see the Integration Services Project.

    I did a quick google search and hit on this. I did not test this myself but
    it looks
    like it may provide an avenue to try...
    -----------------------------------------------------
    Hi all,

    For the people who are still interested, I managed to overcome this problem.
    I went to control panel--> add or remove programs ---> microsoft sql server
    2005. Next, click on the change button.

    You will get a microsoft sql server 2005 maintenance dialog box.
    Under SQL server 2005 common components:
    choose workstation components and click NEXT.

    A installation wizard will pop up:
    click NEXT,
    click NEXT again,
    Click change installed components,
    Then i click on the icon on the left of CLIENT COMPONENTS and choose ENTIRE
    FEATURES WILL BE INSTALLED ON LOCAL HARD DRIVE,
    click next

    After the setup is completed, you will be able to launch BIDS from the
    start-->Programa-->Microsoft SQL server 2005-->SQL Server BIDS.
    ----------------------------------------------------------
    hth,
    bob.



    "Andrew Jocelyn" wrote in message
    news:eQ0og7PaIHA.4808@TK2MSFTNGP05.phx.gbl...
    > Hi
    >
    > I don't have an Integration Services project available when I go to create
    > a new project. How do I install the project template?
    >
    > Also Debugging is not available when I open the file in Visual Studio 2005
    > or BIDS or whatever you call it.
    >
    > Are there any other components I need to install? Perhaps I need to
    > reinstall SQL server but I can't see why it wouldn't install correctly the
    > first time.
    >
    > Please advise.
    > Thanks
    > Andrew
    >
    >



+ Reply to Thread