Hi Gail,

thanks for feedback!

Greets

Henning

Hi jc85,

first I would try to use

CONVERT(char(10),b.start_time,121)

instead of dateadd(dd, 0, datediff(dd, 0, b.start_time)).

Furthermore I advise you not to use functions in WHERE caluses. Modify your parameters so that their...

Sorry, I started with SQL 2008 R2 and BIDS in 2012. 3 years ago we migrated to SQL Server 2012 (and SSDT). So, I know none alternative but I think...

I find that a good source-to-target mapping document, along with comprehensive technical documentation and well thought-out comments in the code (I prefer stored procs over SSIS components) goes a long...

Hello russds,

Do you use the SSDT?

In a package you can use the lookUp transformation-task. In my opinion it's the best way to get the surrogate key from dimensions.

If you use...