Viewing 15 posts - 5,836 through 5,850 (of 9,707 total)
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
Gail already told you what was happening. Restores will clear the plan cache. The fact that this is a secondary log shipping server means that every time a log is...
June 10, 2011 at 3:16 am
A couple of things. You can get this error if the drive that TempDB is on happens to be full or if its Primary filegroup is at its max growth...
June 10, 2011 at 3:13 am
Have you verified that there are no page restores currently happening on the database?
What version of SQL 2k5 are you running? (SP3 or above?) Because if you're running a service...
June 10, 2011 at 3:11 am
Viewing 15 posts - 5,836 through 5,850 (of 9,707 total)