Home Forums Data Warehousing Integration Services SSIS Package Import Problem RE: SSIS Package Import Problem

  • August 22, 2017 at 8:31 am

    #1956178

    Phil Parkin - Tuesday, August 22, 2017 8:01 AM

    Neil Burton - Tuesday, August 22, 2017 7:31 AM

    Phil Parkin - Tuesday, August 22, 2017 7:19 AM

    If you are doing this:

    I'm using the Project Conversion Wizard to import them from the File System to SSISDB

    This statement cannot be true.

    As it happens the file paths are the same between the Dev box and the UAT box .................

    The file paths appear to be absolutely identical.  At the moment the files on both servers are in a folder on the desktop and the path to both folders is the same.  Admittedly this is more good luck than good judgment.  Can you explain what you mean please?

    If a package is stored in SSISDB, it is actually stored in the database and not as a standalone file. If that package needs to call other packages, it needs to call them within SSISDB, not from the file system.

    I see.  So even though the absolute filepaths are the same, that's not the where the master package actually calls the files from, is that right?  That makes sense if the packages need to be imported into SSISDB to run.

    This, does make me (unfortunately) come to the conclusion that you may well have to open your current project in SSDT and manually by changing the references yourself. Sad Then deploy the project to SSISDB. 

    Getting SSDT installed was actually less trouble than I feared and because the files are in relatively the same place they deployed easily enough.  I've got to spend a bit of time knocking the kinks out because of a couple of differences in the UAT platform (and a missed variable name :Whistling: ) but I'm a lot closer than I was this morning.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537