Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 deploy my package

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-22 : 14:37:42
how can i deploy my package to sql server from my client,

the package installation wizard is not open

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-22 : 16:49:56
Here you can see step by with pictures:
http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-23 : 01:35:30
i do it by the orders but in my client i dont find
3.
Running the Package Installation Wizard
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-23 : 03:44:36
There must a file named <Package_name>.SSISDeploymentManifest.
That is to start with doubleclick.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-23 : 09:21:28
yes i see the file on my client, but when i doubleclick on it, he do ot find the
Running the Package Installation Wizard

this wizard is not install on my client, in the server i can do it.(very strange)
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-23 : 09:30:31
You HAVE to do it on the server.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-23 : 15:37:17
tell me if i understand right:

i develop ssis on my client,if i need to add the packaget to MSDB (sql) i need to go to the SERVER and deploy it??

this is the way?
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-24 : 01:25:18
Yes.
Like described in the given link:
1. Creation of the Package Deployment Utility.
2. Copying of the Deployment Folder to the Target Server.
3. Running the Package Installation Wizard to deploy the package onto the target server.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -