March 3, 2014 at 3:14 pm
Hello all!
My name is David and I am new to SQL2012 / SSIS and these forums. I have tried to do this with just knowledge on the web and Internet. I am having some disconnects between what they are saying and what is shown and how to do it unfortunately. SQL and SSIS are not my strong suit, I am a VMware guy.
So here it goes...
Simple Integration Services the idea is to take two flat file CSV's and use the full name to sort both files, then take the data in the rowes from file A and put them in the associated rows in file b example.
File A
Full Name Employee ID Job title Department description Office Location ( take that data and update the corresponding rowes below)
John Smith 554 sr system admin CBP Civilian Chantilly VA
Name Description Title Department Location
John Smith 554 sr system admin CBP Civilian Chantilly VA
The reason we are not just renaming the headers is because this file contains other lookup data for the application it is getting imported back into using a power shell script after the data transfer. It seems so simple but i just cant figure it all out. Any help will be appreciated!
March 13, 2014 at 8:04 am
Hi Goat and wlcome to the boards...
The problem and requirements are not clear from your post.
Are you saying that you have two files with related data
(e.g. a file of staff members and a file of payroll data linked by employee number)
OR
A pair of files with mixed data types - an EDI format
(e.g. file A contains a line for the employee and then some line of other data about that employee, then a line for another employee and some lines of other data about that employee)
And do you need to process the different line types to different output sources or do you need to treat each group of lines as a data set.
Please can you repost and we will do out best to help out.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply