i've created a integration services project and dtsx package to extract data
from one server to another. the package runs fine from the IDE, but i can't
figure out how to deploy it to the server.

any ideas?

Hello cp-bulldog,

There are actually a couple of ways you can do it.

1 Manually. Take the dtx file, put it somewhere and call it from a job or
the like using DTExec
2. You can use the deployment utility to send it to SQL Server


3. You can import the package to SQL Server after connecting to the SSIS
Service in sqlwb


Have a look here in BOL


ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/060b9781-afa0-4c83-b7a1-717e48a55152.htm


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

thanks that helps. i've got another one for ya. should i be able to login
to Integration Services via the SQL Management Studio? when i choose to
login, i do not see the server in the list. is that by design? i'm pretty
sure it is installed, but maybe not configured right?

"Allan Mitchell" wrote:

Hello cp-bulldog,

In the dropdown there should be an SSIS server to which you can connect.


That said. Have a look here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/2c785b3b-4a0c-4df7-b5cd-23756dc87842.htm

and also

http://sqljunkies.com/WebLog/knight_.../05/17769.aspx


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com