What error information do you see in the SQL Server error log?

Do you see error information in the SQL Error Log, post it here, since the vital part of information (look at...

You are welcome !

Post here what have you tried, with table DDL and what's your insert script, it should work and it is better to do it this way.

Welcome !

Have you also specified the column list

Example

CREATE TABLE [dbo].[TestTable](

[Identitycol] [int] IDENTITY(1,1) NOT NULL

) ON [PRIMARY]

You need to use

SET IDENTITY_INSERT TESTTABLE ON

INSERT INTO dbo.TestTable ([Identitycol])

VALUES

(234)

Is this a test machine where you are trying to install SQL 2008?

If it is something not a test environment, I better would not do it and would not suggest...

Have you seen this Page http://msdn.microsoft.com/en-us/library/ms143506.aspx#EEx64

It clearly indicates the versions are supported.

Regarding the best selection of SQL server 2008 edition, you know the requirements at your end, so you...

You are welcome !

Better include what to do if it's 32 bit and what to do if 64 bit.

Absolutely...

When you run manually, it is executing under your security context, but when scheduled it may not be so..

What about the SSIS package info I was asking? Under what security context is the step running?

Can't troubleshoot with that info..

What is it current usage, how much do you want to set it to and why have you decided...

What about the Security settings and the where is the SSIS Package deployed?