SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to deploy packakes to a sql server

How to deploy packakes to a sql server Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Patrick.I
Posted Friday, July 03, 2009 1:13 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, September 30, 2009 6:44 PM
Points: 108, Visits: 196
I have a package that export thata from csv to sql server.
How can i deploy it directly to another server?
Is this possible?

Also what do i need to do if i just need to append data?
Thanks in Adv
Post #746839
CozyRoc
Posted Tuesday, July 07, 2009 3:44 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:35 PM
Points: 586, Visits: 964
Patrick.I (7/3/2009)
I have a package that export thata from csv to sql server.
How can i deploy it directly to another server?
Is this possible?

Also what do i need to do if i just need to append data?
Thanks in Adv


These are actually 2 questions. I would suggest that you post the second question in a separate message thtread.

Can you describe where is the SSIS package currently deployed? Is it:

- deployed on your file system
- stored in SQL Server
- SSIS package store

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #748903
Patrick.I
Posted Tuesday, July 07, 2009 6:58 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, September 30, 2009 6:44 PM
Points: 108, Visits: 196
my SSIS package is deployed in a SSIS package store. e.g samplle.dtsx
Thanks



--------------------------------------------------------------------------------------
These are actually 2 questions. I would suggest that you post the second question in a separate message thtread.

Can you describe where is the SSIS package currently deployed? Is it:

- deployed on your file system
- stored in SQL Server
- SSIS package store
Post #748963
CozyRoc
Posted Tuesday, July 07, 2009 7:02 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:35 PM
Points: 586, Visits: 964
Try to extract the package to a file and then import on the other server to the SSIS store.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Post #748964
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use