You cannot use SSIS with SQL Express. The SSIS components themself are not included with this edition.

Having said that, you have 2 options:

1. Deploy better equipped version of SQL 2005...

Have you tried using wildcards (*, ? ) ? You cannot specify them in the File Connection manager dialog. Right-click on your connection manager and select Properties. And then change...

Can you try to load the file from the root c:\ ? I think the task is somehow messing because of the _spaces_ in the path.

Check this message thread:

http://www.sqlservercentral.com/Forums/Topic423760-148-1.aspx

This is a known issue with Excel data provider.

You can start SQL Job using script task, after you finish loading your dimensions - last step in your package execution. Check this script for ideas how to use SQL...

Sudheer mentioned he doesn't have good programming skills and YES CozyRoc provides commercial products, which simplify and enhance the development experience. Do you see something wrong with that?

SSIS+ is commercial library.

You have to install SSIS+ 1.3 library. You can download it from here. After you install, read the instructions after the installation how to enable the task in your control...

If you don't want to write any script, check the Zip Task.

Check also DTS xChange.

You can implement this with a script task. The script task can be run at the end of your package execution and it will use the SQL Job Agent API...

Are the source Excel files with same structure (number of columns, meaning, etc)? If that is the case, it will be easy. You have to setup data flow task with...

I don't know what component you are looking at, but what you have to do is insert Data Flow Task and then check your destination components for: SQL Server Destination....

You can do DB to DB. There is no limitation. Give it a try. It will probably take not more than 10 mins to setup. Post back your results.

Your problem is not that only one CPU is used. Your problem is that you use OLEDB destination component. This is the slowest possible way to insert. What is the...