Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS new version process Expand / Collapse
Author
Message
Posted Wednesday, April 29, 2009 10:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:36 PM
Points: 110, Visits: 429
I am working on a SSIS package that download data. The package works fine in BIDS and when I import it into SSIS. However I created a Sql Server agent job and I am getting an error. Now I have to change the package in DIBS. Will SSIS and Sql Server agent jobs recognize the changes made in BIDS or do I need to delete the SSIS package and Job and recreate them?

It is easy to see I haven't bought The SSIS book that I was looking at.

Thanks

Quinn
Post #707053
Posted Wednesday, April 29, 2009 11:55 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:17 AM
Points: 4,065, Visits: 5,316
You don't have to recreate the job. You will have to deploy the new version of the package to the expected storage location, though. Just repeat what you did to move the original package to SSIS.

Greg
Post #707101
Posted Wednesday, April 29, 2009 12:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:36 PM
Points: 110, Visits: 429

Thanks Greg!

Quinn
Post #707135
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse