I haven't tested with 2014 DB on SSRS 2012, but I know when I had 2012 DBs using SSRS 2008 it threw up an error when you tried to run...

My apologies John Mitchell, I didn't see your reply!

Thank you all for the advice got it working using a combination of your advice. Really appreciate it, I need to revisit...

Hi Sergiy,

I am getting a The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value error each time I try now, I was...

Thanks alot Luis, I have just tested it. I have values manually done that I can compare to so I know the data is right.

I literally in the meantime started...

Thanks for the link pietlinden, we are automating the report in SSRS so I need to do this via this method this time. However I have wanted to learn more...

Apologies, I did think after I should have put up a sample of the data.

Also, I lifted a part of the sp created but am concentrating on getting the query...

I have literally just searched for how to do it via a query so am battling this now.

Now I have to clear out the cobwebs to work out using...

Get me? Thank you so much for this. That was a wonderful explanation, I understood every word of that.

I was trying to relate it to Excel (am still learning...

Thanks again for the replies, I have definitely been watching videos and learning I guess I do this perhaps too sporadically to take it in and wondered if a course...

Hi All,

Thank you really appreciated.

I have access to Pluralsight for work and was planning to do more of the courses during my week at home babysitting a porch being built.

BFWC...

Thank you both, for the link and help. It is appreciated. I have been doing more in excel so this time gave this a proper go rather than my usual...

Thanks Phil, I am also wondering now if I should just run a job on the server rather than more in SSIS if that makes sense.

I think I am...

We have had the same thing on our server side with new people (myself as one) who edits a report and then the data source wipes itself.

When you installed all...

I have assumed it is just literally minus one haha! I think that might be the answer.

Hi Phil,

Yep not changed the name of the package.

Stages were:

Updated tables in MS SQL

Updated sp in MS SQL

Went into SSIS package

Added additional column to OLE DB source in Data flow...