August 30, 2012 at 10:03 am
i have my column liek this in excel
column1 column2 column3 colum4
product1 product2 product3
product4 product1 product2
product2 product1
now in my table i need to put like this
id product
1 product1
2 product2
3 product3
4 product4
how to do using ssis
August 30, 2012 at 1:07 pm
Please be more detailed in the questions :
do you mean you have 4 excels with the diff column sets you provided.
do you just have one excel with the header row as
col1 col2 col3 col4
and values like
prd1, prd2,prd3,prd4
prd1,prd2,prd3
prd1, prd2
In the above, prd1 on each row....is it really the same prod etc.
Please be specific.
August 30, 2012 at 1:31 pm
its just in 1 sheet.
yes prod1 is same, but i need uniques value from all 3 and put into 1 column in database
August 30, 2012 at 2:43 pm
harri.reddy (8/30/2012)
its just in 1 sheet.yes prod1 is same, but i need uniques value from all 3 and put into 1 column in database
No offense harri but how do you expect people to help with your issues when you don't provide any details? We can't see over your shoulder and we are not familiar with your project. You have so far received no help because you have provided no details.
Look at what you have posted and ask yourself if you think you could answer based ONLY on the details posted.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply