June 1, 2008
What is Task Host Container in SSIS?
- It’s a default container where every single tasks fall into.
- If we don’t specify a container then the task will fall into Task Host container.
- The Task Host is not configured separately, instead, it is configured when we set the properties of the task it encapsulates.
- SSIS extends variables and event handlers to the task through task host container
By Harsh Shah
No Comments » |
Interview, SSIS |
Permalink
Posted by shahharsh
May 18, 2008
| SET |
SELECT |
| Can assign the value of an expression to the variable |
Can assign the value of an expression to the variable |
| Cannot retrieve data from data source. It can only retrieve data from the expressions. |
Can retrieve data from data source and also uses other SELECT clauses (WHERE, FROM etc) |
| Use SET only when you want to assign value of a function result or constant to a variable |
Can use for both i.e. retrieve value of function result |
Example
–Variable declaration
DECLARE
@vName VARCHAR(10),
@vobject_id VARCHAR(30),
@vName1 VARCHAR(30);
–assigning a single value
SET @vName1=’Test Value’;
–Selecting and retrieving multiple values in a single select statement
SELECT
@vName=name,
@vobject_id=object_id
FROM
sys.objects
WHERE
name =’sysrowsetcolumns’
–printing the retrieved values
SELECT @vName1,@vName, @vobject_id
–By Harsh Shah
No Comments » |
Interview, SQL2005 |
Permalink
Posted by shahharsh