User Profile

Collapse

Profile Sidebar

Collapse
jordanm
jordanm
Last Activity: Jun 20 '11, 09:36 PM
Joined: Apr 29 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jordanm
    replied to SSIS: Comparing/Manipulating multiple .CSV files
    in SQL Server
    Yes I'm going to have to do this as I need to perform lookups as well and apparently you cannot perform lookups on flat files. (duh, makes sense)

    Thank you for your suggestion, I will follow it!
    See more | Go to post

      Leave a comment:

    • jordanm
      started a topic SSIS: Comparing/Manipulating multiple .CSV files
      in SQL Server

      SSIS: Comparing/Manipulating multiple .CSV files

      Hello!

      I'm a complete newbie with SSIS and am looking for some tips on what to do in this situation. (Perhaps SSIS won't even allow me to handle this situation and I have to write something myself?)

      Logic:
      CSV source file number 1: [A]
      CSV source file number 2: [B]
      New Output CSV file: [C]

      1) I need to read through both files [A] and [B], searching by a uniqueID in order to find matching...
      See more | Go to post
      No activity results to display
      Show More
      Working...