Viewing 15 posts - 5,851 through 5,865 (of 9,722 total)
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...
June 10, 2011 at 7:15 am
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?
June 10, 2011 at 7:08 am
yayomayn (6/10/2011)
In fact I don't know why you would need...
June 10, 2011 at 7:01 am
Ahha. Now I understand the problem.
In the package white space, right click once and choose Package Variables. It will bring up a new window (at the side or on the...
June 10, 2011 at 7:00 am
Manage linked reports how? What do you want to do with them?
June 10, 2011 at 6:51 am
Mahesh Bote (6/10/2011)
[font="Verdana"]Below is the flow of the SSIS package.
1 'Execute SQL Task'
...
Declare@UserTypeIDBigInt
Select@UserTypeID = UserTypeID From dbo.User(NoLock) Where UserType = 'Customer'
Insert Into <temp Table>
Select<Columns>
From<tables>
WhereUserTypeID = @UserTypeID
...
And in what part...
June 10, 2011 at 6:36 am
sonal_anjaria (6/9/2011)
created a variable, scope is the relevant sequence containermapped the variable in the sql task editor
Not sure what you mean by the above. You've created a variable and mapped...
June 10, 2011 at 6:27 am
tarun.him (6/10/2011)
Thanks Randheer;These questions for sql developer are really helpfull
Be careful about depending on this blog as a resource. Even just looking at today's blog post makes me cringe due...
June 10, 2011 at 6:25 am
Post the code you're using to SELECT the variable value.
Then post the package variable(s) you're using, what their names are, and what level these package variables are created as.
June 10, 2011 at 6:18 am
There is no "right" idea. What tool / software are you using for reporting?
June 10, 2011 at 6:14 am
There's a difference between package variables and the variables declared within an Execute SQL Task. Could you post details on exactly how you set up and populated this variable? It...
June 10, 2011 at 6:13 am
Tom.Thomson (6/10/2011)
SQLRNNR (6/9/2011)
...Whether with formal attire or beach attire, people can't discern where flip flops belong.Surely everyone can discern that they belong on the feet? 😛
In Florida?
Don't be so sure....
June 10, 2011 at 5:40 am
Also, what have you tried so far?
This sounds like a programming class question.
June 10, 2011 at 4:18 am
Look at your SQL Agent jobs. Make sure SA doesn't own any of them. If it does, that might be why things are running under the SA context.
June 10, 2011 at 3:29 am
Don't forget to "fix" SQL Server after your OS defrag. Check your indexes to see if they need to be defragged (because a hard drive defrag will move your SQL...
June 10, 2011 at 3:21 am
Viewing 15 posts - 5,851 through 5,865 (of 9,722 total)