Inside the package at the connection manager (pointing sql 2005) which authentication mode you are using??? If sql then you should use the remote sql login (login in sql 2005...

Refer the below link for scheduling SSIS package

Scheduling SSIS package

Check whether Auto shrink option is enabled?

Check the process that is running at the time of job execution and see what are all the process going on the database...

Refer the below link to upgrade SQL 200 to SQL2005

http://www.sqlservercentral.com/articles/Administration/2987/[/url]

use the below command to leave the time

convert(varchar(25),columnname,101)

Dont forget to change the columnname to your column name in the table

I think you have missed out servername.

Refer the below link.

Scheduling SSIS package

Try re-installing Office Web componets from Sql server setup try to manually run the OWC11.msi file.

If SP2 with critical update is not applied then install the SP2 with critical update.

Refer the below link, i think this may help you.

Scheduling SSIS package

Make sure you have right(i.e Read & Execute) privilege on the backup file for sql server 2005 startup account as it clearly saying that access is denied (in my ...

Simple way is to use Import \ Export wizard.

Right click on the db and select Import \ Export wizard.

In the source , select the excel file

In the destination, select the...

1.) Username and password should be Remote server's username and password. If you are going to use windows authentication then remove username and password option and then use "Trusted_Connection=yes;" option.

2.)...

When you install SQL, automatically SQL service will be added to service manager.

Can you pls give more description about the error you are getting.

Check the below link , i think this would help you to solve the problem

SQL Server 2005 Installation errors

Hi,

Pls find the steps below.

1.) Make sure you have installed .Net framework 2.0 in your system before proceeding

2.) Download Install Microsoft SQL Server 2005 Express Edition.

3.) In SQL2000 you...

Try using the below command, it will work.

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=servername\instancename;UID=username;PWD=password;',

'select * from databasename..objectname');