If you want to use the SQL SELECT INTO Statement to make a copy of the table then you do not want to truncate the table.

Drop the table and perform...

I never used the EW's slick tool but I have used DTS Backup.

http://www.sqldts.com/242.aspx

Why are you creating a new SQL Server 2000 machine?

As was suggested you might want to consider upgrading.

The following article should get you started.

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration

Hopefully the following article will be of help to you.

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/c9459c41-ce11-4cdb-a330-ad9092948a6d

Usually you do not logon using the SQL Server Agent Account.

Are you using a service account for the SQL Server Agent?

If you get the error from BIDS then you have a permissions issue with the Account that you are using to logon.

Why are you concerned about displaying this table from Access?

This is not a security risk.

You could revoke permissions to the public role but no one would have access to the...

This is an SSRS issue.

Are you having issues with other reports that are executed on the same Server?

What happens if you execute the query in SSMS?

Can you create and test an ODBC Connection?

hussain27syed (8/10/2011)

---

I have a table with 433 columns, each is a parameter on which the user is rated. All parameters are not applicable to all users.like in the sample...

Listed below is a link to Brian...

Sounds like a homework problem. There is no way that this is a business problem.

I do not see how this scenario had any practcal application.

Consider structuring your data data correctly...

They will be executed Simultaneously unless you specify a precedence...

Change the file extension to .xlsx.