Running dtsx file from Visual Studio

  • Is there anyway to run a dtsx file from Visual Studio? I am importing a series of tables from different Access DBs and I have to change the source DB for every table I import. I use Visual Studio to change the source DB, but I have to use Integration Services Package Execution Utility to run the dtsx file

  • Business Intelligence Development Studio comes with the SQL tools. Create a new SSIS project and add existing file.

    I suggest you do some research into SSIS as I suspect it may not debug without a little editing or variable setting.

  • wow jimbo, as always another vanilla answer with no details

  • Would you like step by step screen shots or to be pointed in the right direction and assisted with learning? If you aren't willing to help yourself then don't expect assistance. This is a volunteer site and not an alternative to google.

    Here, I've googled BIDS for you.

    http://msdn.microsoft.com/en-us/library/ms174181.aspx

  • Oh, and the green "play" button will start the debugger for you

  • guerillaunit (2/2/2012)


    wow jimbo, as always another vanilla answer with no details

    If you want someone to do the work for you, hire a consultant.

    Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

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