CODEWITHSUNDEEP
mergessislookup
user10159714
user10159714

Reputation: 13

ssis how to add all columns from another source without join criteria?

I want to read properties from my source file, and the add the properties to all records in the file itself

So I'd like to join the Element reading the FileProperties to all rows from the data...

Data1 FileProperty1 Fileproperty2
Data2 FileProperty1 FileProperty2

In fact, I just want to add the columns from the property dataset, to each row from the data... how can I do that ? I try merge and lookup, but I don't have any Id to match witch, just need to append...

Upvotes: 0

Views: 352

Answers (2)

KeithL
KeithL

Reputation: 5594

  1. Create your file property variables

  2. Add a script task to control flow:

  3. Add variables as read/write

  4. Add the following script (I gave you 1 property as an example)

    System.IO.FileInfo fi = new System.IO.FileInfo("[Your File Path]");
Dts.Variables["FileSize"].Value = fi.Length;

  5. Add your dataflow and connect to script task (script first)

  6. Add a derived column to DF and add additional columns for your variables.

Upvotes: 1

J Sidhu
J Sidhu

Reputation: 677

Use your property file as a source to a pivot transform to transform the rows into a list of columns. Now that you have all the properties in a single row, simply use the pivot output as a source, and use merge transform to merge these new columns with the other file.

More info on how to use Pivot transform

Upvotes: 0

Related Questions