Viewing 15 posts - 5,836 through 5,850 (of 9,715 total)
Deepak_Vad (6/10/2011)
Also please can you suggest a good book on SSIS? or best method to learn SSIS?
There's a good beginner's book called "Hands-On Microsoft SQL Server 2005 Integration Services" by...
June 10, 2011 at 8:59 am
Deepak_Vad (6/10/2011)
June 10, 2011 at 8:55 am
Okay. I see what you mean now. You are correct.
June 10, 2011 at 8:37 am
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
Viewing 15 posts - 5,836 through 5,850 (of 9,715 total)