+ Reply to Thread
Results 1 to 4 of 4

Thread: Where are the 2005 SSIS packages?

  1. #1
    Barn Regular grnzbra is an unknown quantity at this point grnzbra's Avatar
    Join Date
    May 2009
    Posts
    66
    Rep Power
    3

    Where are the 2005 SSIS packages?

    I have been told "Here is a 2005 database and SSIS package XYZ has two errors in it. Fix them." I can't find them. I've gone to the Integration Services Engine, but the folders there are all empty (except for other empty folders)

    I also ran a search on XYZ.dtsx and found it (along with all the other .dtsx files) in someone's folder inside of a zipped folder. BMS can't brows beyond the zipped folder, so I coppied all the .dtsx files to my folder and then told BMS to open that file. It seems to have various errors, so I assume that I am not doing this correctly (I have no trouble creating my own packages). Also, since this is supposed to be a duplicate of a database with packages being run every night, it seems that there should be working SSIS packages SOMEWHERE. Where do these thing normally hide? (All of the tutorials I've gone through had me set up a special folder for packages I created)

  2. #2
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,533
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    You can choose to store them inside SQL Server itself, so could be in the MSDB database. Perhaps they are stored there?
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  3. #3
    Barn Regular grnzbra is an unknown quantity at this point grnzbra's Avatar
    Join Date
    May 2009
    Posts
    66
    Rep Power
    3

    Thank you. That did the trick.

  4. #4
    Barn Newbie Tetch is an unknown quantity at this point Tetch's Avatar
    Join Date
    Sep 2010
    Posts
    6
    Rep Power
    2

    Thanks, that's a good work

+ Reply to Thread

Similar Threads

  1. SSIS - Forum
    By darck1 in forum Community Support, Suggestions & Feedback
    Replies: 12
    Last Post: March 19th, 2010, 03:43 PM
  2. SSIS - Joins
    By darck1 in forum SQL Development
    Replies: 3
    Last Post: March 19th, 2010, 03:12 PM
  3. Sybase to SQL Server 2005
    By Flam in forum Microsoft SQL Server
    Replies: 2
    Last Post: December 28th, 2009, 07:02 PM
  4. SQL2000Analyzer equivalent in 2005?
    By Rebelle in forum Microsoft SQL Server
    Replies: 5
    Last Post: November 13th, 2009, 02:38 PM
  5. Pivot with out Aggregate Function -SQL 2005
    By MySQL in forum Microsoft SQL Server
    Replies: 6
    Last Post: July 21st, 2009, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO