Stack Overflow
Stack Overflow

Questions tagged [dataflowtask]

113 questions
2
votes
1 answer

xml read file and write to xml file

I have xml data in below format. I want to convert this to proper xml format where I can use data flow task -> xml source component to import data into DB. Please help me out what should be done?
Dinesh
  • 67
  • 9
2
votes
1 answer

SSIS - How can a power query's output be the import of another power query in a data flow

In an SSIS Data Flow I want to include 2 Power Query Sources, in order to pass the output of the 1st one to the input of the 2nd one. I am guessing i need some in-between step to join the 2 PQs, or not?
sugarakis
  • 117
  • 9
2
votes
1 answer

Using variables in SSIS Data flow task and Execute process task

I created a package and added a data flow task that reads the data from database and creates a flat out xml file. It then stores the file in the path I have given and the execute process task uploads it to a remote server. Below is how the structure…
Naphstor
  • 2,356
  • 7
  • 35
  • 53
2
votes
1 answer

SSIS Data Flow Update

I am trying to figure out the best way to approach the following scenario. Overview Payments are collected over the course of the day and stored in a table (SQL Server). At the conclusion of each day, these payments are to be exported and inserted…
dotariel
  • 1,584
  • 12
  • 23
2
votes
2 answers

How to avoid 'number stored as text' error when exporting data from SQL Server to Excel using SSIS DatFlowTask

I am using a SSIS Data Flow Task to export data from SQL Server to an Excel destination, but while exporting it converts int values to "Numbers Stored As Text" Excel cells and every cell gets this error "number stored as text" with a green tag. Can…
vinisha9
  • 91
  • 1
  • 2
  • 8
2
votes
1 answer

Selectively Execute Dataflow tasks in SSIS based on a If else condition

I want to create a SSIS package which will have two data flow tasks. If today's date is startdate of the Month it should execute one dataflow task(which actually has a month end report), else then it should execute another dataflow task(which is a…
vinisha9
  • 91
  • 1
  • 2
  • 8
2
votes
2 answers

SSIS: How to add variable parameter to Lookup Transformation Editor?

I am modifying an SSIS package in which some of the Data Flow Tasks have Lookup Transformation Editors. The modifications I am making entitle the passing of an additional parameter to some stored procedures, and this parameter comes from a variable…
plantbeard
  • 358
  • 7
  • 16
2
votes
1 answer

SSIS SQL Task with parameters not creating temp table

I've got a SQL task that creates a temp table, then a data flow task that selects from that temp table. Everything works fine and dandy, but when I add a parameter to the SQL task, the data flow task fails, saying the temp table wasn't created. Hard…
Jooooosh
  • 331
  • 2
  • 4
  • 13
2
votes
1 answer

Recording error descriptions in an SSIS Data Flow (VS2008 BIDS)

I'm trying to use event handlers to log errors in my SSIS packages. Unfortunately there is no option to add event handlers to individual tasks within a data flow task; I have consequently added an event handler to the overall data flow task at the…
christopherlovell
  • 3,800
  • 4
  • 19
  • 26
2
votes
0 answers

SSIS: "Error: The result of the expression "@[User::FileName].....cannot be written to the property"

I have been trying for the last 10 hours to solve the following problem: I have a ForEach Loop container that is enumerating Excel file names in my Control Flow. Within the ForEach Loop container I have an Excel Source that imports data into…
J.S. Orris
  • 4,653
  • 12
  • 49
  • 89
2
votes
0 answers

Import data from .xls to table by removing unwanted columns?

I am creating a SSIS package to import data from .xls(EXCEL sheet 97-2003) to Sql DB.But my .xls file consists of unwanted data for first 4 rows .How can i skip those data. My file look like Create by: Modified By: Date: Team: Id value …
user3203331
  • 429
  • 2
  • 7
  • 23
2
votes
2 answers

Does variable value set by Row Count Transformation take effect during execution of DFT in SSIS? or Conditional Split can read a variable correctly?

I have a SSIS package where1 record (hard coded) flow through. I have variable in DFT scope. I assign value to variable using Row Count Transaformation. The value should be 1 i verify it by using script component. public override void…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
1
vote
0 answers

DataFlow JOB IAM Can not allocate sha384 (reason: -2)

I am trying to launch my workflow but it generates this error. command:python nbo.py --temp_location gs://xxxxx/tmp/ --project xxxxx --region us-central1 --runner DataflowRunner --job_name xxxxx --output_table xxxxx.xxxxx --input_subscription…
andres acosta
  • 11
  • 2
1
vote
1 answer

Are SSIS properties DefaultBufferMaxRows and DefaultBufferSize relevant for text file imports?

We use SSIS to import .csv files to SQL Server. DefaultBufferMaxRows and DefaultBufferSize are set to their defaults (10k rows, 10MB) DefaultBufferMaxRows and DefaultBufferSize can impact loading from a database table because you can only read the…
Rory
  • 959
  • 10
  • 22
1
vote
0 answers

I am not able to see Data Flow Task Plus ext [ Cozyroc SSIS + ( 2.0 Licensed=Trial)] in SSIS Toolbox

The applications I am using on my machine : Visual Studio 2019 SQL Server 2016 SQL Server Management Studio (SSMS) 19 Cozyroc SSIS+ 2.0 ( Licensed : Trial ) After installing the cozyroc SSIS+ ( Roaming Mode ) , I am not able to see it in SSIS…
Tanmay Salunke
  • 11
  • 1
1
2
3 4 5 6 7 8