+1 for surrogate keys. the keep the fact table small (in terms of bytes, not columns) and provide you with a level of 'protection' from changes in the source...

Think of it in terms of a retail distribution network.

You will need a warehouse (data warehouse) where all the products (information) is collected and kept

You will need a store (data...

+1 from me

Phil, Gail and Koen are some of the most generous and helpful forum members on any board I visit and their opinions and advice have saved (or...

I would data flow the value to a recordset destination to an object variable and then use a For-Each loop to extract it. As there will only ever be...

Ouch!

They have a big budget for this project though, so they can afford some nice toys 😀

HUB_InvoiceHeader

SAT_invoiceHeader

Googlefor: Data Vault

you could look at using the Optimise for first N rows hint. This will change the query plan so that the query can start returning data earlier, even though...

yup. You might need to use a script component or WMI. Here are a couple of links

http://www.bidn.com/blogs/mikedavis/ssis/157/ssis-wmi-event-watcher-check-file-exist-creation

http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis

@informer:

CSV stands for Comma Separated Value. The structure of the file is just ANSII code. You could create the file in Word, Notepad, or DOS editor....

Thanks Koen, If its good enough for you, then I will take that option 🙂

Next question. Which files need to be in SCC and which one don't. ...

dates in excel are actually numeric. the integer is the days and the decimal is the time.

If you have access to the data in any format other than Excel...

If the files have an identical structure and it is only the target name that changes then yes, otherwise you might as well have four DFTs (plus DFTs can operate...

my first reaction would be line terminators

Firstly, Excel and SSIS will put you in a world of pain. Do you really need to use Excel as a source or destination. If you have another...

Its late on Friday at the end of a hard week...

Setting the Fail values is not going to help in this instance because the package is crashing rather than failing.

How...