I am impressed with Eirikur Eiriksson. That looks like a neat solution.

Thanks

E

Having spent a lot of time looking into this I am very concerned over the SMDL Report Model file. I cant seem to find a way to get it down...

All is now kind of calm

from a very quick look at this the tables of interest appear to be Catalog and DataSource. Querying from DataSource where link IS NULL shows...

Open SQL profiler,

start a new trace on the servers your query may be running against.

You can now run the reports and see which server they are hitting and...

I have done the certification and will continue to do so. The reason I do it is that as a freelancer anything that will raise me to the top of...

Have not proved this is the fix but... If you go back to PowerPivot in the ribbon and then click 'Field List' then that seems to get what I want....

You tube probably has some good starter stuff. Powerpivot for Excel 2010 book by Marco Russon and Alberto Ferrari. There are obviously newer versions of this but that's the one...

please define capture.

I have attached a simple screen shot. Basically put a flat file or OLEDB destination in the data flow , click on the derived column and drag it...

my starting point would be to look at a script task using C#. I have done similar with flat files but not to Excel. But you should be able to...

It depends on how you are setting the file name for the connection manager. Doing multiple packages you may not have changed where the file connection is looking at originally....

Awesome response. You learn something new every day.

E.:cool:

Not sure if this is what you want but.

I built two date tables

select distinct [YEAR] from data.vwDimDate D

-- 2009 to 2016

select distinct [YEAR] from data.vwDimDate2 D

-- 2010 to...

sorry double posted

Would love to help but I have always done this sort of thing through a C# script task in the package. It just looks at a directory and sees if...

I did a little trial and error (banging head on table) and it looks like MIN with a FILTER would be the way to go. I got round it by...