I agree that the error handling is very clunky in SSIS, but as for the suggestion to script event handlers, would you please provide more details? thanks,

I don't know if this will help, but I code the path with one variable and the file name with another and then combine them at the end. The...

Doing any kind of query on that kind of thing becomes pretty evil. You effectively are unable to do efficient date-range queries (i.e. 01 March 2009 10:00 through to 05...

Whilst there may be more efficent mechanisms to generate the data itself (you may get better with a loop in a stored procedure or other evils), it's a lot...

Not everyone is an expert at every part of SQL Server and while this persons article does not show the best approach to this, it is sufficient enough to point...

After many days of trial and error I was finally able to solve this problem. In my case I needed a least squares regression line for the previous 28...

This is an old topic, but I recently had to produce a Regression Line in SSAS 2005 for several measures for the previous 28 days. After many days of...

I agree with the comment that the date and time dimension need to be seperated. I've seen the combined design, and it rapidly becomes unwieldy. It also makes...

I don't think you can avoid a design that does that through the database design, if only because somehting has to go in first.. It does, however, account for...

An interesting design challenge. I don't have a good proposal off the top of my head, but will think about this. One thing your proposed solution would run...

Without knowning the entities represented by the tables, no answer can be given for why it's wrong, or even that it is wrong, although it probably is. If you...

OK, if it's for your dad, then don't listen to your teacher. All the seats should be in their own table and then joined to the booking detail. ...

If this is for a school assignment, you really should be working this yourself. We normally help those trying to solve their job related issues.

I don't know why you have the seats broken out by different tables depending on the type. These should be combined and identified by an additional field if necessary.

Two ways to do this: Probably better to have a table with shows, a table with seats in the theater, and then a detail table that joins show and...