No announcements
Found 2929615 threads
-
0 VotesHow to Declare a variable in Execute SQL task to Insert a row..?
and map it in parameters window in Execute SQL Task.Answered | 3 Replies | 20477 Views | Created by Roger Binny - Tuesday, July 7, 2009 8:43 PM | Last reply by Thisme - Wednesday, August 1, 2012 3:17 AM
-
0 Votes
How to declare a table variable in SSIS and then insert rows into it
SQL Insert, Update, Delete, and Select statements return a large amount of informational data on the execution of the statements.Answered | 12 Replies | 31335 Views | Created by CostinP - Thursday, September 9, 2010 11:44 AM | Last reply by Joifer Santos - Friday, March 15, 2013 1:18 PM -
0 Votes
How to pass a variable from Execute SQL Task to SSIS Package variable
http://dataqueen.unlimitedviz.com/2012/08/how-to-set-and-use-variables-in-ssis-execute-sql-task/ Regards, RSinghAnswered | 2 Replies | 4944 Views | Created by District9 - Friday, June 7, 2013 4:24 AM | Last reply by Chongtham Rajen Singh - Friday, June 7, 2013 12:51 PM -
0 Votes
Insert Statement in execute sql task
Take a execute SQL task and configure it like: SQL Statement: INSERT INTO [tempdb].Answered | 3 Replies | 8386 Views | Created by muppasuresh - Tuesday, December 8, 2009 6:17 AM | Last reply by Nitesh Rai - Tuesday, December 8, 2009 8:06 AM -
0 Votes
How to insert data in table using variable in Execute SQL Task
Can you just give me simple example in which data is comming in variable and using exeute sql task we have to insert thata ...Answered | 6 Replies | 22011 Views | Created by Ajay Singh Rawat - Saturday, November 3, 2012 8:12 AM | Last reply by giladma - Monday, November 5, 2012 1:17 PM -
0 Votes
Execute Sql Task and Global Variables
Output On the ParameterMapping Tab direct the new SSIS-Variable to the SQL Variable: Variable: ...Answered | 2 Replies | 8230 Views | Created by rimmey14 - Friday, March 4, 2011 11:15 PM | Last reply by Christa Kurschat - Sunday, March 6, 2011 3:16 PM -
1 Votes
Execute SQL Task Failing
Hi Triumph, In addition to Visakh’s answer, if you use the Output parameter method, you need to set the ResultSet property of the Execute SQL Task ...Answered | 16 Replies | 2436 Views | Created by Triumph Spitfire - Monday, June 9, 2014 7:23 AM | Last reply by Mike Yin - Monday, June 16, 2014 7:20 AM -
0 Votes
Execute SQL task and variables...
You'd use an Object type if there were more than one row - and then use that Object variable in a Foreach Loop Container.Answered | 4 Replies | 4574 Views | Created by jsanthanam - Friday, March 19, 2010 9:37 PM | Last reply by jsanthanam - Monday, March 22, 2010 5:23 PM -
0 Votes
SSIS Execute SQL Task
But when i run thi spackage i got an error message as follows [Execute SQL Task] Error: Executing the query "INSERT INTO ...Answered | 14 Replies | 17077 Views | Created by sweety19 - Tuesday, February 16, 2010 4:57 PM | Last reply by sweety19 - Tuesday, February 16, 2010 10:30 PM -
0 Votes
How to pass variables to Execute SQL task
If you use RETURN in the stored procedure, the the 1st execution passes the value back to your package variable, then this variable would be used as ...Answered | 1 Replies | 3688 Views | Created by Jyo1105 - Thursday, February 2, 2012 9:03 PM | Last reply by ArthurZ - Friday, February 3, 2012 3:02 PM -
1 Votes
Passing variable to Execute SQl Task
Remove the USE Warehouse and use a object from Connection mamager see propertie in EXECTUTE SQL TASK EDITOR "Connection" parameter setting ...Answered | 3 Replies | 4524 Views | Created by kchokkal - Friday, August 21, 2009 4:28 PM | Last reply by Nik - Shahriar Nikkhah - Friday, August 21, 2009 4:55 PM -
0 Votes
Insert Data into Variable in Sql task ado.net
I've set up my variables but when i write the SQL (as a Sql command expression ) with the variable parameter, I can't see where my ADO ...Answered | 4 Replies | 5634 Views | Created by rchokler - Friday, October 29, 2010 1:57 PM | Last reply by DataScout - Tuesday, January 18, 2011 7:37 PM -
0 Votes
Dynamic SELECT and saving in a variable in Execute SQL Task
Hi Krishna: I am calling SP from my Execute SQL task.Answered | 3 Replies | 3811 Views | Created by syedripon - Tuesday, February 28, 2012 12:25 AM | Last reply by syedripon - Tuesday, February 28, 2012 2:23 AM -
0 Votes
Log No of rows affected by SQL Execute task
Hi rkshan, Are you putting both Queries in the Execute SQL Task ?Answered | 5 Replies | 7575 Views | Created by xXShanXx - Monday, October 25, 2010 5:44 PM | Last reply by xXShanXx - Tuesday, October 26, 2010 10:17 AM -
0 Votes
SSIS - Using Variables in Execute SQL Task Error
Issue is with variable @columnz.Answered | 1 Replies | 1475 Views | Created by scottgis - Tuesday, March 3, 2015 11:54 PM | Last reply by Vaibhav.Chaudhari - Wednesday, March 4, 2015 6:57 AM -
0 Votes
problem with execute sql task, single row resultset
How will I access the value inside the script task .Answered | 2 Replies | 4423 Views | Created by arun_arunarun - Tuesday, March 2, 2010 8:57 AM | Last reply by Kunal Joshi - Tuesday, March 2, 2010 9:39 AM -
1 Votes
In SSIS - Execute SQL Task
For example, Use try catch and declare two variables to find the count of those tables and If @Var1 = @Var2 then select 1 as [Status] else 0 as [Status].Answered | 3 Replies | 2953 Views | Created by HYDBA - Wednesday, November 2, 2011 3:26 PM | Last reply by SqlRockss - Wednesday, November 2, 2011 6:20 PM -
0 Votes
Row Count for Bulk Insert task
This row count shud reflrect the rows inserted wit te bulk insert task. hence was trying to print it first, to see if it shows the count of rows ...Answered | 19 Replies | 16345 Views | Created by Desigal59 - Monday, March 16, 2009 6:34 PM | Last reply by Desigal59 - Tuesday, March 31, 2009 9:29 PM -
0 Votes
execute sql task connection as variable
By providing an expression for the 'Connection' property you are indicating the name of the Connection Manager that you wish the Execute SQL Task to ...Answered | 6 Replies | 2185 Views | Created by arkiboys - Friday, October 14, 2016 12:53 PM | Last reply by Guoxiong Yuan - Friday, October 14, 2016 4:52 PM -
0 Votes
Mapping variables in Execute SQL Task
In exec sql task, go to exepressions property SQLStatement source.Answered | 8 Replies | 2430 Views | Created by Royal Thomas - Thursday, February 28, 2013 1:50 AM | Last reply by Royal Thomas - Thursday, February 28, 2013 8:05 PM - Items 1 to 20 of 2929615 Next ›
No announcements
