July 20, 2009 at 4:11 pm
Hello Experts,
I have a flat file from customer with following format...
Column1 Value1
Column2 Value2
Column3 Value3
...
...
...
...
Column1000 Value1000
Now the question is how can I treat first column (column 1 to column1000) all data are tables COLUMN name and 2nd column all data are VALUES (value1 to value1000) and map the different columns to different tables?
Before I use to get...columns are as header row in first line and then values are from 2nd row onwards line by line in a flat file, this one above file explained is unique...any expert advice is highly appreciated.
I am using SSIS 2008 with SQL Server DB.
Thanks,
Suresh
July 23, 2009 at 2:56 am
I would say just change the script that generates the source file to keep the column names in the header row. I am sure it is very simple to do that.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply