hanks, that helped me, I hope it's the best way to do that.

anyway I've scheduled a SQL agent job to run every 30 minutes.

That's a good one Nikos, Thanks for sharing your experience.

nikosag (10/5/2010)

---

Hello,

I do the same in my production system with the following, relatively simple 4 steps job:

Step1: Alter dev database to...

Henrik, It helped me too! Thanks a Million!

Cool, thanks, I really was interested in SQL stats topic.

Cool, Thanks, I was having the same problem while trying to create any maintenance plans on R2.

the update called "sqlncli.msi"

41822

I don't think there's such a way of handling that error other than to set the connector between the tasks to "complete" instead of "success".

I'm not quite sure I understand your question, but I think you can add a sort before the lookup and pass through only the desired columns.

what's your solution? I'm having the same problem? can you help if you even still remember it?

attaches is sample data and create table script

I'm having the same problem, can you tell what was your solution!!

my data type are the same...!

Thanks

----------------------

my mistake, data type wasn't matched !! duh !!

Thanks Steve, It worked for me too..... I hope next releases, SSRS gives us the option to rename it or use the GUID.

Thank you for such a great video and series, god bless for sharing the knowledge...

That really depends on the size of the database and the frequently of accessing the data, you don't need much resources if it's a small database, 2 GB of memory...

Thanks, that helped me today 🙂

Thanks, i did it through a T-SQL statement, I hate SSRS expressions 😉