Stop restoring to the server.

Literally, that's the only way to "solve" the issue.

You...

srinadh.ramineni (6/12/2011)

---

My Requirement is:

I have a OLTP database, using this i should create a dimensional model (Star or Snowflake schema). Using this model i should give some reports using SSRS.

NOTE:...

Or Thread Certifiable? @=)

You are not wrong in that it is Microsoft recommended.

Jeffrey...

There's a good beginner's book called "Hands-On Microsoft SQL Server 2005 Integration Services" by...

Deepak_Vad (6/10/2011)

---

Thanks a ton for your time & patience with me... I almost gave up but you both of you are really helpful. I have a quick question.. what is...

Okay. I see what you mean now. You are correct.

Glad we could help.

That is an incorrect assumption....

Is the variable being manually set by any sort of config file?

Deepak_Vad (6/10/2011)

---

Not only this query... even if I try to use...

SELECT 1

And if I wanted to pass the value 1 to variable it does not work. So I am...

Eh-hem. I think you need to go back and look at your variable scope. The picture you posted does not jive with the comment "I have a package level scope"...

Simon,

If you're having specific issues, please post your question as a new topic on the board with as many details as you can about the problem. We'll be glad to...

Deepak,

Go into SSMS and run your SQL Query against the proper database. Does it actually return a value?

EDIT: More to the point, does it only return 1 value?

yayomayn (6/10/2011)

---

Yes in your execute SQL task you must map the result of your SQL variable to a variable in the package.

In fact I don't know why you would need...