Hi

I need to autostart the SQLServer Agent thro script(shown in earlier post) and i get error.

Also i couldn't able to find the option "Autostart SQL Agent" what u have mentioned in your...

Hai,

Yes, iam trying to install the packages on the target server .

Iam able to connect to Integration Services Server in Management studio. By clicking Stored Procedures folder , i get...

Hai,

Sorry, i could not able to understand 'access to the SSIS Server'?

How to check the insufficient access in SSIS?

Iam able to connect to Integration Services Server in SQLServer Management...

Thanks for your reply.

May i know whick checkboxes have to be enabled  and could u explain in detail.

Thanks

Nirmala

Thanks for responding.

I think SQLServer account is,  Network Service account (NT AUTHORITY\NetworkService).

If this would be the problem, what should i do to resolve it.  Pls helpme.

Once again thanks,

Nirmala

Thanks for viewing my question and responding to it.

Iam using Microsoft SQLServer 2005 Developer Edition and the product version is 9.0.1399 RTM.

While installing this,  i have configured as,

 Service Account:...

Thanks for your early reply.I tried on that, and it is working correctly.

Meanwhile i also tried with OpenRowSet and iam able to run the query correctly.

Once again thank you

Nirmala

Hai

           Thank you very much for your reply.

I mean the OPENROWSET method to import and i have used the query,

Insert

into [TESTDB]

Hai,

As a beginner, you can read and try all the lessons in ,

"Integration Services Tutorial" in SQLServer 2005 Books Online.

To know about various transformations, see

"Integration Services Transformations" in SQLServer...