You do not have the appropriate edition of integration services installed. File system tasks and pretty basic and covered by the standard edition of SSIS, but it must be...

INSERT ?

Perhaps you have left out some vital information.

I have never had a problem with underscores within a user name either. I do, however, hate typing them so I tend to avoid them.

Yes and no.

You can have several OLEDB destination components (or even SQL Destination components) loading into the same table at the same time. However, they may not be able...

That's probably your safest option.

You have lost your argument when you resort to name calling.

Please act like a professional.

Either use Parameters.Refresh, or add two parameters. The first parameter is the RETURN_VALUE parameter for the procedure. Since it happens to be an integer data type, the parameter...

I am not sure I understand what you are trying to build, but SSIS will not magically know what holidays you want to exclude.

Yes, but it is often a bad idea.

You can use the same table for multiple data flow destinatio components. As long as you have not specified RetainSameConnection=True on your...

You could do this in a script component withing your data flow, but Lynn makes a great point: why are you taking nice normalized data and messing it up?

If you can be sure every ID in the CTE will be in the first table you are deleting from, you could use OUTPUT.

Start with the basics: did you update statistics after upgrading?

You probably should create a table that has the lunch type and the scale, rather than hard-coding the names into a case statement like this.

CASE

WHEN Lunch IN ('Lasagna','Sausage') THEN 'High'

WHEN Lunch IN ('Salad','Non-Fat Yoghurt') THEN 'Low'

WHEN Lunch IN ('Burger King') THEN 'Really High'

END As FatContent

I would go with option 3.

At the beginning of the process, if the file does not exist, create one.

You can create an empty file through the command line, via a...