Questions tagged [dataflowtask]
113 questions
0
votes
1 answer
How to access task (DFT) level variable in SSIS in case same name variable? I seem to be accessing package level variable in Conditional split
I have 2 varaibles name Row_Count 1st at package level and 2nd at task level and both have default value zero.
I have assigned variable value through Row Count Transformation
and checked it for condtion in conditional split.
It seems in Row Count…
Pritesh
- 1,938
- 7
- 32
- 46
0
votes
1 answer
Accessing SSIS Variables in Data Flow task
In an SSIS script task, and of the SSIS variables can be accessed using the following syntax:
Dts.Variables["VariableName"].Value
However, in a data flow task the syntax changes a bit to this:
Variables.VariableName
At the same time, certain…
NealR
- 10,189
- 61
- 159
- 299
0
votes
2 answers
How to increase the speed on update in ssis
I have SQL Command task in SQL Server which is updating only 20 rows per second, but I need to update more than 200,000 rows which is taking time. When I am using SCD (Type 2) it is neither inserting or updating any records. (Not even giving any…
Zerotoinfinity
- 6,290
- 32
- 130
- 206
0
votes
1 answer
temp table vs data flow task on physical table
Here is the scenario
I have one staging table for csv file which is My source I am loading it into physical staging table I will be doing transformations on this staging table data in later part of package I need fresh data (as it is from…
Ashish
- 3
- 3
0
votes
1 answer
Redirect error rows only when conversion fails
I have a data conversion task in ssis in which I am changing datatype of a column and configured error output as "Redirect Rows".
But when I am running the package I am getting this, which is executing both success and failure part even though there…
Zerotoinfinity
- 6,290
- 32
- 130
- 206
0
votes
2 answers
SSIS Cannot Convert Unicode to non Unicode String Error
Our team has created a SSIS Package that imports data from an Oracle Source into a SQL Database, the package used Oracle Provicer for OLEDB to client to the Oracle SOR.
The major Data type difference between the Source and the Destiantion Databases…
Dinesh Menon
- 105
- 1
- 2
- 11
-1
votes
1 answer
SSIS - In DFT, how to each row input to exe and read the output for each row?
In the Data Flow Task, I need re-direct each row to exe and get the output for each row, similar to script component.
I tried to use Process in Script Component, but it is throwing exception "StandardOut has not been redirected or the process hasn't…
prashanth
- 1
- 5
-3
votes
1 answer
Is it possible to save a data flow task to an independent file?
In SSIS, I should save a part of control flow to another file and take it when needed. Is it possible?
Burak Karakuş
- 1,368
- 5
- 20
- 43