No announcements
Found 2270900 threads
-
1 VotesPassing 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 | 4278 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
SSIS Variables in SQL Task
Create a variable of type object: tableList Create an execute SQL task.Answered | 5 Replies | 1724 Views | Created by alabil1969 - Thursday, June 4, 2015 1:16 PM | Last reply by Patrick Hurst - Thursday, June 4, 2015 1:50 PM -
0 Votes
passing variable to sql task
appi_newborn is correct, I didn't mentioned at what you tried to do at all, you just want to sum up first four variables, so you don't need any execute ...Answered | 4 Replies | 4444 Views | Created by SeaCloud - Thursday, December 2, 2010 4:27 AM | Last reply by SeaCloud - Thursday, December 2, 2010 9:40 PM -
0 Votes
OLE DB Destination - table name or view name variable - fast load
Then append that value inside the SQL task/ script task to create the whole statement including creation of the table with that variable.Answered | 5 Replies | 18207 Views | Created by mystikal2k2a - Tuesday, August 7, 2012 1:02 PM | Last reply by Reza Raad - Tuesday, August 7, 2012 8:34 PM -
0 Votes
how to pass variable using execute SQL task Component
You have to set the result of your Execute SQL Task to a variable (called result set).Answered | 5 Replies | 3881 Views | Created by Ajay Singh Rawat - Friday, August 17, 2012 7:31 AM | Last reply by DotNetMonster - Friday, August 17, 2012 10:32 AM -
0 Votes
Pass Variable in Execute SQL Task
I pick option 1 , but task is still getting fail .Answered | 8 Replies | 1927 Views | Created by AshishSingh_DWH - Wednesday, May 14, 2014 10:15 AM | Last reply by Visakh16 - Friday, May 16, 2014 1:21 PM -
0 Votes
can we pass a file name to sql task with variable help
In the Execute SQL Task, on the general tab there is a property SQLSourceType = Variable which allows you to specifiy the query to run via a user::variable in SSIS.Answered | 3 Replies | 3781 Views | Created by Ajay Tomer - Friday, July 31, 2009 4:17 AM | Last reply by Nik - Shahriar Nikkhah - Friday, July 31, 2009 1:16 PM -
0 Votes
Pass Database name dynamically in to a variable using SSIS
Hello Sudeep, I have similar issue where i need to load 5 tables and then update a column using execute sql task in ssis . so first i created a ...Answered | 4 Replies | 7836 Views | Created by sql9 - Wednesday, February 24, 2010 4:50 PM | Last reply by BiDev_Raj - Thursday, January 21, 2016 7:14 PM -
5 Votes
Table name variable failes in OLE DB connection
Please make sure your variable is of type String, and select -- table name or view name variable - fast load ...Answered | 6 Replies | 1044 Views | Created by falcon00 - Tuesday, July 1, 2014 6:26 PM | Last reply by Mike Yin - Tuesday, July 8, 2014 7:21 AM -
3 Votes
Pass Variable for OLE DB Source with connection to Oracle
I have one SELECT that return an information From a table in Sql server I created 2 variable.Answered | 14 Replies | 7183 Views | Created by Marcos Aguiar Jr - Tuesday, September 29, 2009 12:39 PM | Last reply by Ricardo Nepomuceno - Wednesday, September 30, 2009 1:41 PM -
0 Votes
How to set table name to a variable in OLEDB destination task?
Then you are creating the table (whose name is alread saved in the variable) and then using a data flow task to load the data into the newly created table ...Answered | 7 Replies | 7969 Views | Created by Sach Vaidya - Wednesday, March 13, 2013 12:08 PM | Last reply by Nitesh Rai - Thursday, March 14, 2013 8:39 AM -
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 | 3397 Views | Created by Jyo1105 - Thursday, February 2, 2012 9:03 PM | Last reply by ArthurZ - Friday, February 3, 2012 3:02 PM -
0 Votes
OLE DB Source using table name variable
If you create an OLE DB Source and set Data access mode = "Table name or view name variable" right from the start, then how do you define the ...Answered | 10 Replies | 12642 Views | Created by mruniqueid - Monday, January 22, 2007 7:39 PM | Last reply by ChrisN2 - Friday, July 1, 2011 3:26 PM -
0 Votes
How to pass string variable to a data flow task?
Hi, 1--Execute sql task, full result Set. that will save in object type variable ( Select name from sys.tables).Answered | 12 Replies | 11314 Views | Created by Sqldbar2 - Monday, June 13, 2011 9:10 PM | Last reply by Sqldbar2 - Wednesday, June 15, 2011 1:14 AM -
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 | 4717 Views | Created by District9 - Friday, June 7, 2013 4:24 AM | Last reply by Ch. Rajen Singh - Friday, June 7, 2013 12:51 PM -
4 Votes
How to pass Variable as a Table Name?
In order to generate table with a variable name using T-SQL, you will need to use dynamic SQL.Answered | 10 Replies | 3151 Views | Created by Bangaaram - Tuesday, January 3, 2012 4:04 PM | Last reply by Bangaaram - Thursday, January 5, 2012 4:53 PM -
0 Votes
Passing variable from script task to execute sql task
I assume that there's a variable named value, int type in a SSIS package.Answered | 3 Replies | 3835 Views | Created by DIEGOCTN - Monday, April 10, 2017 4:02 PM | Last reply by DIEGOCTN - Tuesday, April 11, 2017 10:35 AM -
0 Votes
pass ssis variable to sql task stored proc
In my opinion, use String, the database does not care, but you may end up converting it in the Execute SQL, the SQL itself would be select a from b where cAnswered | 2 Replies | 2646 Views | Created by arkiboys - Thursday, January 19, 2012 5:20 PM | Last reply by arkiboys - Friday, January 20, 2012 11:32 AM -
0 Votes
pass a table name as a stored proc variable
try this DECLARE @SQLString nvarchar(500); DECLARE @ParmDefinition nvarchar(500); DECLARE @Table ...Answered | 3 Replies | 3010 Views | Created by neophytenik - Wednesday, May 19, 2010 9:50 PM | Last reply by padmabhushanv - Thursday, May 20, 2010 10:06 AM -
0 Votes
Passing SSIS Variables Between SQL TASKS IN Loop Containers
Here you want to pass the values to expressions by using variables, for suppose you want to capture the value from Execute ...Answered | 1 Replies | 5164 Views | Created by mindscape777 - Saturday, October 17, 2009 3:19 PM | Last reply by Murty Addanki - Thursday, October 22, 2009 11:11 AM - Items 1 to 20 of 2270900 Next ›
No announcements
