Discussion SSIS Packages in SQL 2008

[VIJSQL01]

hi,

i am trying to create a SSIS package in SQL 2008. The steps i am following are as follows.

a. Open import/export wizard
b. Specify data source as SQL Server Native client 10.0
c. Specify server name
d. Use SQL server authentication
e. Choose database
f. In the next page, specify the destination as microsoft excel
g. specify excel file path and also the excel version
h. in the next page select the option 'write query to specify the
data to transfer
i. add the query into the SQL statement window
j. 'in the Save and Run Package' page, enable Run Immediatly and Save SSIS Package(SQL server is enabled here)
k. In the Save SSIS package page, i gave the package name and using the sql authentication i am moving to the next page.
l. in the next page, i am saying Finish

I am getting the error message as follows.....

Executing (Error)
Messages
Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
 
Warning: Preparation SQL Task 1: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
 
Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE `Query` (
`period` LongText,
`HPI_1..." failed with the following error: "The Microsoft Jet database engine could not find the object 'Query'.  Make sure the object exists and that you spell its name and the path name correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 (SQL Server Import and Export Wizard)

Please let me know, why i am getting this error.