Deployment question

After I develop my report on my development computer how do I actually
deploy the report on the client's site?
ThanksOn Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> After I develop my report on my development computer how do I actually
> deploy the report on the client's site?
> Thanks
As long as you have the Report Manager setup/configured correctly, you
should be able to just upload the RDL file into the main directory or
some subdirectory that you create beforehand. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Will that also create all data sources?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>
> As long as you have the Report Manager setup/configured correctly, you
> should be able to just upload the RDL file into the main directory or
> some subdirectory that you create beforehand. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||When you develop your report in BI studio you have created data sources.
When you deploy from BI Studio it will also create the data sources. This
can be scripted but the easiest way is to deploy from the development
environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
> Will that also create all data sources?
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||I did not see scriting option there. Can you give me more details, please?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:etjFzY0tHHA.4424@.TK2MSFTNGP04.phx.gbl...
> When you develop your report in BI studio you have created data sources.
> When you deploy from BI Studio it will also create the data sources. This
> can be scripted but the easiest way is to deploy from the development
> environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
>> Will that also create all data sources?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>|||In Book Online search on the word scripts.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:OIzQsw0tHHA.536@.TK2MSFTNGP06.phx.gbl...
>I did not see scriting option there. Can you give me more details, please?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:etjFzY0tHHA.4424@.TK2MSFTNGP04.phx.gbl...
>> When you develop your report in BI studio you have created data sources.
>> When you deploy from BI Studio it will also create the data sources. This
>> can be scripted but the easiest way is to deploy from the development
>> environment.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
>> Will that also create all data sources?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>>
>

Deployment of system

I am about to start developing a system using VB 2003 and SQL Server 2000. On my development computer, I am going to use MSDE for the database, which I guess I will later be able to export to my client's SQL server 2000.

Now, I am a bit worried. In my local computer, I can develop a system which runs locally very well. So, I am very sure I will be able to develop one for my client. But when I later deploy it to the client, it will have to run on a server and client machines.

My question is, how easy or complex is it to deploy such a system from my standalone platform to a client-server one. I have adequate experience developing stand-alone systems.

I am about to get started so please kindly give me ideas on the best path to take.

Hi there and welcome to client server development :-)

Its quite easy if you are developing on a MSDE and want to deploy that later on a Std / Ent Server. It is reduced to making a backup and restoring the backup on the server, normally that should be all except for the server users, which additionally have to be scripted and deployed.

BTW: If you want to deploy it on productional systems on Std / Ent Editions, why don′t you use SQL Server Dev Edition to develop the applications. It would be more comfortable for you and it would be a more soution-near development.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanx a lot for the info.

What I am about to develop is really a small system that would not warrant me going for any extra development tools more than what I have - cost is an issue.

You said that the database it is a matter of backup/restore. What about the VB application? Lets take the simplest example below.

Supposing I have a VB form bound to a datasource coming from some SQL Connection (localhost) on my development PC. The form will run on my computer because its connection is there.

Now, what happens if I take the above (app and database) to client-server environment. I restore the db on server and install app on client (?). But the connection in app is to localhost on my development PC. So it will not run in client-server until I modify the connection to point to the new server. Am I right or wrong?

|||Hi,

yes you are right, but that a point of configuration. I think right now you are using configurable settings in your application, so just add another setting to pass the servername, port etc. to the data source creator (or whatever you implemented).

The developer edition isn′t expensive at all. Should be available for 49$ (around),so developing on development edition will help you in many cases spending (/wasting) time for configuring something or getting a fst info from the server.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||Be blessed. I'll check out all your suggestions.

Deployment error

HI,

I am using .NET 2003 on my pc. I installed reporting services 2000 on my pc as well.

I have a remote computer (server) with sql 2000.

I created a report using the reporting services, and now I want to deploy it to the report server.

When I do it I get: " The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing"

I dont know how to configure reporting services, I know how to create reports, so i hope you can help me step by step.

For a strat I wish you can help me configure it to work om my pc (I installed sql 2000 on my pc as well)

Thanks,

Target Folder: ReportServer

TargetServerURL:http://127.0.0.1/ReportServer

Double check the datasource you are using. Go into the properties of the datasource, click edit, then 'Test Connection'. Probably a worth a check.

Deploying sub-reports

I have many reports that are compiled as embedded resources in my ClickOnce
application. All of the reports work on my dev computer when run from Visual
Studio or when installed via ClickOnce on my dev computer.
On client computers, the reports with sub-reports fail. The following error
message is shown where the sub-report should be:
"Error: Subreport could not be shown"
Since the reports work on my dev computer, the problem seems to be a
difference between the Visual Studio report viewer and the redistributable
report viewer.
Has anyone else seen this problem? Can you give me any advice?I had a problem like this before and found it to be a problem with the
regional settings on the client running the report.
"John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
>I have many reports that are compiled as embedded resources in my ClickOnce
> application. All of the reports work on my dev computer when run from
> Visual
> Studio or when installed via ClickOnce on my dev computer.
> On client computers, the reports with sub-reports fail. The following
> error
> message is shown where the sub-report should be:
> "Error: Subreport could not be shown"
> Since the reports work on my dev computer, the problem seems to be a
> difference between the Visual Studio report viewer and the redistributable
> report viewer.
> Has anyone else seen this problem? Can you give me any advice?|||Immy, thanks for the reply. Regional settings do not seem to be the problem
in my case -- my dev computer and the clients are all using "English
(Canada)".
I may try to deploy the .rdlc files directly instead of embedding them in a
report dll.
"Immy" wrote:
> I had a problem like this before and found it to be a problem with the
> regional settings on the client running the report.
> "John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
> news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
> >I have many reports that are compiled as embedded resources in my ClickOnce
> > application. All of the reports work on my dev computer when run from
> > Visual
> > Studio or when installed via ClickOnce on my dev computer.
> >
> > On client computers, the reports with sub-reports fail. The following
> > error
> > message is shown where the sub-report should be:
> >
> > "Error: Subreport could not be shown"
> >
> > Since the reports work on my dev computer, the problem seems to be a
> > difference between the Visual Studio report viewer and the redistributable
> > report viewer.
> >
> > Has anyone else seen this problem? Can you give me any advice?
>
>

Deploying Reporting Services

Hi,

I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.

But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.

Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying

"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "

I've been trying to fix it for past few days but I couldn't.

Can anyone help me on this., Please.

Thanks in advance

Kusuma

Hi,

Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx

Thanks

|||

The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1

Deploying Reporting Services

Hi,

I've installed reporting services and reporting services sp2 on my local computer and I have admin rights on this computer.

But when I am trying to deploy reports in the report server, It is asking for login and password. If I give my machine login and password, it is not taking.

Even if type http://localhost/reportserver or http://localhost/reports it is giving an error saying

"CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\1bbf2d18\2968d42e\App_global.asax.2trocnva.dll' -- 'Access is denied. "

I've been trying to fix it for past few days but I couldn't.

Can anyone help me on this., Please.

Thanks in advance

Kusuma

Hi,

Check this link:http://blogs.msdn.com/astebner/archive/2005/04/08/406671.aspx

Thanks

|||

The solution from this thread below worked for me. I had to add write access to the Network Service account to the c:\winnt\temp directory.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588823&SiteID=1

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deployement to a local machine

Hi,

I have developped a program with VB 2005 with a DB using sql server and I would like to know if I use this program on another computer what's the minimum requirement.

Dotnet 2.0 and sql server? But do I have to install the full sql server version or just a patch to be able to run that kind of program?

Thx in advance

I do think that to deploy a VB.NET 2005 application, the client computer must have the .NET 2.0 framework installed.

If the application will access a remote SQL Server that is all that is necessary.

If the application will require that a SQL Server be also installed, then a 'licensed' edition of SQL Server must also be installed. Depending upon the requirements, the 'free' SQL Server 2005 Express may be sufficient. Check here for information about which SQL Server edition may best fit your needs.

Deploy SRS created in 2005 to SQL 2000 SRS

I have SQL 2005 on my dev computer. Can I deploy reports from it to a SRS 2000 instance? If not, what do I have to install on my dev computer to generate SRS 2000 reports?

You would need to install VS.Net 2003 and the developer plug in that comes with Reporting Services 2000 install.

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!
This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/default...46&Product=sql
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.c om...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.com...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/defaul...546&Product=sql
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.com...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!

Deploy SQL Server Database in an ASP.NET Application?

hi

i want to develop a web application that use SQL Server Database, i have installed SQL Server & VS.NET in my local computer and i'm ready to develop, but before getting started, i want to know how i will upload mydatabae in my host,

actually i want to know should i know the settings & properties of my host that support SQL Server, or without know them i can devekop my apploication and after developing localy with just a few tasks upload my ( Sql Server) database???

i'm worry actually about this, plz say what you know about this.
thanks>>should i know the settings & properties of my host that support SQL Server

Yes, contact your hosting provider, or several, to get this information.

Deploy Integration Service

Hi All,

I had created a Intergration Service on my workstation computer, run as well.
now i want to set a scheduling and run that Intergration Service on server, so should i deploy my Intergration Service to the server?

i had try to use my workstation computer,
open the "SQL Server Management Studio" connect as "Intergration Services", and Import the dtsx file (Package file) in it. but if i had some modify on that dtsx file, i need import the dtsx file on the server again?

any another way to deploy my Intergration Service?

Thx a lot.
Laputa

Have you tried the deployment tool that is provided with SSIS?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/0f5fc7be-e37e-4ecd-ba99-697c8ae3436f.htm

-Jamie

|||This is a good reference.
Thank your very much.

Deny PC Access

I would like to restrict access to our live database by the computer
name. Is this possible in SQL 2000? If so, does anyone have a
recommendation on how to do this?
Thank you!
AngieHi
You could restrict using IP address with a firewall, but it could be easily
bypassed. Using multiple subnets may be difficult to implement if you needed
some interaction between the two.
John
"angela.y.austin@.gmail.com" wrote:
> I would like to restrict access to our live database by the computer
> name. Is this possible in SQL 2000? If so, does anyone have a
> recommendation on how to do this?
> Thank you!
> Angie
>