Viewing 15 posts - 46 through 60 (of 101 total)
[p]Or may I know how to pass value to a package level variable in SSIS Agent job..?
Any suggestions please..[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 28, 2010 at 7:21 am
[p]I don't think so it is possible. The better way is to remove header and footer. :unsure:[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 28, 2010 at 5:12 am
[p]Any suggestions please.. :pinch:[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 28, 2010 at 5:02 am
Create package level variables and pass those values across all tasks in the same package.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 25, 2010 at 4:47 am
If possible please attach screen shots.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 11, 2010 at 7:22 am
You can change Compatibility Level in SQL Server 2005 by right clicking your database -> Properties -> Options -> Compatibility Level.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 11, 2010 at 12:35 am
As u said u just installed ...u can remoe and install again that the better way..
IF u have any data or changes..take backup of all database and do the above...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 8, 2010 at 5:11 am
Good question.. Thanks
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 8, 2010 at 3:22 am
Yes, it is good question but where and how we can use this? Anybody can explain with an example?
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 19, 2010 at 12:26 am
Really interesting and good question. :Wow:
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 14, 2010 at 4:27 am
Replaced with "User::sourceTable" and tried, but again the old value only it is taking.
Now I removed "sourceTable" value from Variables window.
Got error saying Incorrect syntax near 'FROM' ...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 13, 2010 at 7:58 am
I given just like sourceTable in the ReadWrite variables list for the script task.
And I used MsgBox to know the value like:
MsgBox(Dts.Variables("sourceTable").Value.ToString())
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 13, 2010 at 7:23 am
Yes, it is package level variable. But it is resetting to old value i.e.: "SE_DatabaseServer".
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 13, 2010 at 7:09 am
What type of connection you are using in connection manager?
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 13, 2010 at 5:34 am
Buddies,
I am using SS2005 and I ran the first query: DECLARE @TimeStart DATETIME
DECLARE @Time DATETIME
DECLARE @TimeEnd DATETIME
DECLARE @I INT
DECLARE @Count INT
SET @I = 0
SET @Count = 0
SET @TimeStart = GETDATE()
SET...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
May 11, 2010 at 11:58 pm
Viewing 15 posts - 46 through 60 (of 101 total)