No announcements
Found 3627616 threads
-
0 VotesAssigning values to variables
Then you should put the value in double quotes: if status="single" then ....Answered | 2 Replies | 1077 Views | Created by Dave Pri - Wednesday, February 13, 2013 2:45 PM | Last reply by Dave Pri - Thursday, February 14, 2013 9:01 PM
-
2 Votes
Not able to Assign Value to a Variable
The part of your Execute SQL Task that doesn't look right - and should have caused an error - is how you're assigning that return value to the variable.Answered | 7 Replies | 4615 Views | Created by ashishpatil - Friday, March 26, 2010 2:44 PM | Last reply by ashishpatil - Tuesday, April 6, 2010 4:37 PM -
1 Votes
Assign variable a value, using it's name as a string
You can use a dictionary to achieve a somewhat similar functionality.Answered | 3 Replies | 7485 Views | Created by Gary Oak - Friday, June 26, 2009 5:42 PM | Last reply by Gary Oak - Friday, June 26, 2009 7:21 PM -
0 Votes
Assign value to a variable
Use a SQL Statement of "SELECT @@IDENTITY", select a "single row" result set.Answered | 1 Replies | 4647 Views | Created by NSG12 - Wednesday, March 24, 2010 9:45 PM | Last reply by Todd McDermid - Wednesday, March 24, 2010 10:15 PM -
0 Votes
Variable Won't Take Value Assignment
Then, wherever it is you intend to use the value, you can cast it or use a data type conversion...Answered | 4 Replies | 4899 Views | Created by cdun2 - Monday, June 8, 2009 3:19 PM | Last reply by Eric Wisdahl - Monday, June 8, 2009 7:30 PM -
0 Votes
How to assign a value to a variable
Sorry Guys, I thought may be the variable might be the problem but the whole thing is different and my original question is in this ...Answered | 12 Replies | 1408 Views | Created by SqlDev12 - Tuesday, March 4, 2014 8:49 PM | Last reply by SqlDev12 - Tuesday, March 4, 2014 9:48 PM -
0 Votes
Problem with assigning value to variable
See http://technet.microsoft.com/en-us/library/ms140355.aspx Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF ...Answered | 5 Replies | 2507 Views | Created by Aminesh - Monday, January 2, 2012 10:01 AM | Last reply by Randy Paulo - Tuesday, January 3, 2012 1:34 PM -
1 Votes
How To Assign datetime value to variable
Aminesh , Please follow the link and go through the “Populating a Variable with a Result Set” section to understand how to populate the value to a ...Answered | 2 Replies | 5779 Views | Created by Aminesh - Friday, October 23, 2009 8:22 PM | Last reply by Bharani 3010 - Monday, October 26, 2009 8:49 AM -
0 Votes
Custom Task - Variable Value Assignment
Hi Kumar, The value of a custom variable can be a literal or an expression: 1.Answered | 2 Replies | 2517 Views | Created by Naveen Kumar T - Friday, July 13, 2012 12:45 PM | Last reply by Eileen Zhao - Thursday, July 19, 2012 8:10 AM -
1 Votes
assigning two values to a variable in ssis
I am passing the values in IN condition by assigning a variable to parameter in OLEDB Source.Answered | 2 Replies | 1572 Views | Created by SaiKrishnaTeja - Wednesday, September 18, 2013 3:28 AM | Last reply by SaiKrishnaTeja - Friday, September 20, 2013 6:56 AM -
0 Votes
Assigning formatted value to variable
I want, instead of printing that value, to have it assigned to a variable.Answered | 1 Replies | 302 Views | Created by Jason Esah - Friday, July 24, 2015 12:13 AM | Last reply by - Friday, July 24, 2015 6:51 AM -
1 Votes
Assigning a variable a value from an Exec
An alternative is to insert the results into a table and then get the value from the table: Declare @ReportDate DATETIME, @RecordCount INT, @DateText ...Answered | 3 Replies | 753 Views | Created by Faraz A. Qureshi - Friday, May 11, 2018 9:49 AM | Last reply by SQLNeophyte - Friday, May 11, 2018 2:08 PM -
1 Votes
SQL query returns value but EXEC SQL Task fails to assign variable
As an alternative ou can return the value without using a resultset using PL/SQL.Answered | 16 Replies | 4212 Views | Created by Thursty - Wednesday, January 22, 2014 6:32 PM | Last reply by davidbaxterbrowne - Wednesday, January 22, 2014 10:27 PM -
0 Votes
assign max value to a variable in ssis
public void Main() { string strPath = ...Answered | 3 Replies | 1928 Views | Created by DileepReddyAchhala - Monday, June 20, 2016 10:38 AM | Last reply by Adi Natarajan - Wednesday, June 22, 2016 2:51 PM -
0 Votes
Assigning value to variable with sql connection
The SQL query returns 96 and that is the value I wish to assign to the variable, so although I don't receive an error with the code you have shown me, it is not quite what I ...Answered | 3 Replies | 3547 Views | Created by Jackson Riley - Sunday, December 20, 2009 3:12 AM | Last reply by Jackson Riley - Sunday, December 20, 2009 4:23 AM -
0 Votes
Assigning value to SSIS variable in script task...
I am writing the code in the script task along with the exception handling task and i used ...Answered | 4 Replies | 1988 Views | Created by Suu30 - Monday, May 13, 2013 10:16 AM | Last reply by SSISJoost - Monday, May 13, 2013 11:37 AM -
0 Votes
Assigning values to variables from derived column
have a look at my blog.Answered | 2 Replies | 6758 Views | Created by KKKKKKKKKKKK1234 - Wednesday, February 16, 2011 2:28 PM | Last reply by Sudeep Raj - Wednesday, February 16, 2011 4:08 PM -
0 Votes
How to Assign value of Derived Column to variables using script component.
You can use expression builder for that.Answered | 2 Replies | 4826 Views | Created by HiteshLall - Monday, March 3, 2014 6:08 AM | Last reply by Visakh16 - Thursday, March 6, 2014 5:15 PM -
0 Votes
How to assign null value to a date variable in VB.NET
You could also try system.Datetime.MinValue if your date value has to be assigned as something.Answered | 9 Replies | 114767 Views | Created by AntoniaLazari - Thursday, April 19, 2007 4:36 PM | Last reply by VB.NetNewBee - Tuesday, October 4, 2011 7:50 PM -
4 Votes
HOW TO ASSIGN A VALUE TO A VARIABLE IN SSIS DATAFLOW TASK
The variable should be the one you want to assign value to now. and name of variable ... i usually have 0.Answered | 7 Replies | 58661 Views | Created by Praveen_bids - Thursday, November 22, 2012 11:59 AM | Last reply by Dia.Agha - Friday, November 23, 2012 5:30 AM - Items 1 to 20 of 3627616 Next ›
No announcements
