SSIS Package ~ Publishing Back to Server?
Posted on 2007-11-20
Hi, I have an SSIS package I created via the import/export wizard in management studio. Something happened to the package and it said I had to update the metadata for the source fields or something... so I looked it up on the web and it said I had to go into the SSIS designer to edit the package. So, I went into BI studio...created a new integration services package and then loaded the SSIS package from the server into it.
I believe I fixed the meta data problem... but now my problem is how do I get the package back on the server? I saved it and tried doing a build but its not saving the package back to the server... help please, this is a critical package that has to run daily. :(