Top "Dataflowtask" questions

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 …

sql ssis sql-like case-statement dataflowtask

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), …

ssis flat-file dataflow dataflowtask

Update table using SSIS

I am trying to update a field in a table with data from another table, based on a common key. …

sql-server-2005 ssis dataflowtask

"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 …

sql-server-2005 ssis import flat-file dataflowtask

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 …

ssis rowcount dataflowtask script-component

To read Xml file from variable in XML Source in SSIS

I am getting the result in variable through web Service Task as shown in below image, Then I have used …

xml xslt ssis dataflowtask

SSIS Cannot convert between unicode and non unicode...but it's not true, how come?

I have a simple DTSX that takes in some data, and write it to a SQL server DB, on this …

unicode ssis oledb dataflowtask