This site has many free articles that will go into depth and help you out.

http://www.rkimball.com/html/designtips.html

Typo error here:

'modal'

should be 'model'

Doubt if it helps much.

Changing the sheet name dynamically often loses the transformations as well.

The easiest and most reliable way to get around this is to make sure you always import with the same...

In general, I assume that if I see two graphs then I assume 4, as hyperthreading is et on as standard, howeverm I do see your point.

I just googled around...

Go into task manager on the server.

Click performance tab

From menu select - View - CPU History - One for each cpu

This shows how many cpu are there.

You can then work...

If you are using a mapped rive, then make sure the drive is mapped on the client that you are editing the package on.

Make sure nobody has a lock on...

You are in effect creating dynamic sql by not declaring the table or column name in the statement.

The ? paramater is to be used for values rather than table/column names.

I...

Take a look at the adverts around this site.

Check out Red-gate, Apex etc.

It all depends what requirements you have. Best way is to list the requirements down and then see...

I think the problem is that you are trying to create an extension - .dash26/01/06.

Slashes are not allowed in filenames. Try formatting the date to remove slashes, dots etc...

Copyfile method is for moving files but keeping their original name.

Look into Copy method. See link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/c98c7d8c-ba9e-46b7-bc29-14ab1b7f06f3.asp

There are many methods with their own advantages and disadvantages when populating datamarts, some forced upon the developer.

In terms of populating target tables, you need to be able to identify...

The whole point here is that by questioning the integrity of dts you may as well not use it.

Package logging will record any errors that occur. Success or failure of...

Most reliable way is to put another step in between the tasks writing an insert into a table, uniquely identifying each along with a date/time.

That way, whichever route is taken...

Just checked and there is no easy way I can see to go back to the step that fails and register it as a success. If you call an activex...

The trick is what you tell it to do on failure. IE if fail go this route and if pass go to this route.

The whole point I am trying to...