Viewing 15 posts - 5,851 through 5,865 (of 9,726 total)
John Mitchell-245523 (6/10/2011)
I think if you look in the Variables window, you'll see the value for the variable the last time the package was loaded.
That is an incorrect assumption....
June 10, 2011 at 8:19 am
Is the variable being manually set by any sort of config file?
June 10, 2011 at 8:12 am
Deepak_Vad (6/10/2011)
SELECT 1
And if I wanted to pass the value 1 to variable it does not work. So I am...
June 10, 2011 at 7:22 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"...
June 10, 2011 at 7:19 am
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
Viewing 15 posts - 5,851 through 5,865 (of 9,726 total)