I'd have to agree with earlier posts. In the set up we have here I dont see any real beneifts. I've tried on a larger set of data but it...

Thanks for the post. It's just helped me out.

How well do you know your data? Does your system allow for history to change? if your pulling out a max date and only selecting >= to that date is...

Is this any good - http://facility9.com/2009/04/23/populating-us-federal-holidays-in-a-calendar-table/

or -

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

We have a similar issue in the UK but it's only a 10 min job to crib it from...

Andrew,

Is this any good for you? - http://www.opm.gov/operating_status_schedules/fedhol/2010.asp

btw, Groundhog Day was on TV this weeend in the UK, hadn't seen it in years 🙂

I'd agree with feakesj, we've got an 'is working day' bit field. Work out the days by counting that value between the two dates, simple. Looks this is an over...

I missed that 🙁 your right.

If these SQL statments are going to be run a lot you could put them in a sproc.

The execute SQL task can also execute sprocs.

Is the SMTP set up correctly? enabled Windows Authentication for your connection?

I'd suggest the redirect as my favoured approach but if your using buk insert this wouldnt be possible in just one task.

Personally I'd be looking as to why the...

If you dont want to use SSIS then you could use OPENROWSET.

e.g.

select *

from OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Text;Database=C:\test;HDR=NO',

select * fromExcelSpreadsheet.csv')

go

Depending on the complexity Id suggest using OPENROWSET to transform your data straight into the...

One of the other big differencies between a relational database and a datawarehouse is that you'll see more denormalization in a datawarehouse.

Dosnt look like replication as the destination looks like only 1 table. If so this looks like a perfect job for SSIS.

If your new to SSIS I'd do some light...

Here’s a question not many people consider about self-service BI - can it lead to bad decision making (a core reason for BI)?

Take this scenario - A set of experienced...

I always read articles about date and time dimensions; just to see how they compare to the script I take with me wherever I go, just to see if there’s...