Advertisement

11.20.2007 at 05:19AM PST, ID: 22972520
[x]
Attachment Details

SSIS Package ~ Publishing Back to Server?

Asked by Roxanne25 in MS SQL DTS, MS SQL Server, SQL Server 2005

Tags: ssis, package, publish, server

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. :(Start Free Trial
 
Keywords: SSIS Package ~ Publishing Back to Ser…
Title
1 From DTS to SSIS
2 SSIS solution for access databases
3 Error Loggin in SSIS
4 ssis
5 SSIS package: determine if multiple fil…
6 SSIS PACKAGE + 200 DATAFLOW …
 
Loading Advertisement...
 
[+][-]11.20.2007 at 05:46AM PST, ID: 20319535

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.20.2007 at 06:20AM PST, ID: 20319807

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.20.2007 at 06:37PM PST, ID: 20325099

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.22.2007 at 04:56AM PST, ID: 20334163

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, MS SQL Server, SQL Server 2005
Tags: ssis, package, publish, server
Sign Up Now!
Solution Provided By: abhijit_k
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628