Stack Overflow
Stack Overflow

Questions tagged [dataflowtask]

113 questions
17
votes
2 answers

Is it possible to perform a "LIKE" statement in a SSIS Expression?

I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be able to say.. SQL CODE WOULD BE: CASE WHEN Column01 LIKE '%i%' THEN '0' ELSE '1' END In SSIS Expression Language that would be: [Column01] ==…
iamtheratio
  • 569
  • 4
  • 9
  • 16
12
votes
1 answer

"The selected data source is on remote computer" error when creating an SSIS job

I am in the process of developing an SSIS job on my workstation which a Data Flow Task open a comma delimited flat file on my local workstation and imports the data to a SQL server database on a remote server. When I try to select the destination…
Michael Kniskern
  • 24,792
  • 68
  • 164
  • 231
12
votes
6 answers

How do I get SSIS Data Flow to put '0.00' in a flat file?

I have an SSIS package with a Data Flow that takes an ADO.NET data source (just a small table), executes a select * query, and outputs the query results to a flat file (I've also tried just pulling the whole table and not using a SQL select). The…
theog
  • 1,064
  • 2
  • 20
  • 33
8
votes
3 answers

How to programmatically create an SSIS Package?

I am trying to programmatically create an SSIS package containing a simple data flow from table A to table B in the same database. I am using the example given here. The package gets created and saved to a dtsx file, but when I open it in visual…
user20358
  • 14,182
  • 36
  • 114
  • 186
6
votes
4 answers

Update table using SSIS

I am trying to update a field in a table with data from another table, based on a common key. If it were in straight SQL, it would be something like: Update EHSIT set e.IDMSObjID = s.IDMSObjID from EHSIT e, EHSIDMS s where e.SITENUM =…
thursdaysgeek
  • 7,696
  • 20
  • 78
  • 115
6
votes
2 answers

Can't open excel file with SSIS unless it is manually saved

I'm having an issue processing an excel file with SSIS unless I manually open the file and click 'save'. I've noticed that it doesn't mater if the file is .xls or .xlsx The file is downloaded to excel from an SSRS project I am able use a File…
Doolius
  • 854
  • 6
  • 18
5
votes
1 answer

SSIS DataFlowTask DefaultBufferSize and DefaultBufferMaxRows

I have a task which pulls records from Oracle db to our SQL using dataflow task. This package runs everyday around 45 mins. This package will refresh about 15 tables. except one, others are incremental update. so almost every task runs 2 to 10 mins.…
Maximus
  • 792
  • 9
  • 19
4
votes
2 answers

SSIS Data Flow Task Errors : SSIS Error Code DTS_E_OLEDBERROR and SSIS Error Code DTS_E_PRIMEOUTPUTFAILED

In my Data Flow Task (DFT ), I have OLE DB Source and Destination . In connection manager, my connection is OLE DB too. Source is pulling 80000 records and loading in Desti. Simple package. My Package is breaking on OLE DB Source. The point to note…
Ankita Potdar
  • 67
  • 1
  • 9
4
votes
5 answers

Measuring Progress of SSIS Data Flow

I am running a SSIS package to load say a million rows from a flat file, which uses a script task for complex transformations and a SQL Server table destination. I am trying to figure out the best way (well, ANY way at this stage) to write out to a…
Glenn M
  • 455
  • 2
  • 8
  • 16
3
votes
2 answers

Row Count of various files with in a For Each Loop Container

I have a Row Count transformation in Data Flow Task and this Data Flow Task is in a For Each Loop Container. So when I am running the package I'm getting the row count for only one file but not all the files.Can anyone help me with this
venugopal
  • 79
  • 10
3
votes
1 answer

SSIS Package Works in VS but not in SSIS because of ODBC Data Flow Task Error

We have a test package that was designed using VS2017 that has one "Data Flow Task" object with "ODBC Source" and "ODBC Destination" objects within it. The package is simply trying to move records from table 'Table_1' to table 'Table_2' in the same…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
3
votes
1 answer

Sorting Merge Join output

I have two merge joins in data flow task. I want to set the IsSorted property for inputs of second merge join. But it is giving error as "The IsSorted Property must be set to True on both sources of this transformation." following is the image of…
Amol R
  • 87
  • 8
3
votes
3 answers

How to retain null values in flat file destination in ssis package

I have created an ssis package. in dataflow task, i am passing data from oledbsource to flat file destination. i want to retain null values in flat file but it is coming blank.
Asin
  • 63
  • 1
  • 9
3
votes
1 answer

C# Setting Custom Properties of SSIS custom data flow component through custom UI

I'm having a real problem trying to set a custom property of a data flow component I've created through a custom form. The value I'm assigning is just now being set, the custom property either remains the original value or stays null. In my…
zeencat
  • 589
  • 1
  • 5
  • 26
2
votes
2 answers

How to handle an empty query result on a DataFlow Task?

I'm iterating several years with a Dataflow inside a Foreach Loop, but there are some years that will not return any data, therefore they SSIS package fails, is there a way to handle this? To tell the package to ignore those blanks and keep…
user1112251
  • 119
  • 1
  • 4
  • 13
1
2 3 4 5 6 7 8