Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sharu_tan
Starting Member
11 Posts |
 Posted - 2008-04-10 : 02:55:07
|
| Dear All,We are using UnPivot task to convert the columns into rows using the Excel File as source. But the Excel file column names are changing frequenly sometimes its having only 4 columns sometimes its 10 columns. Everytime we are checking and unchecking the column list in Unpivot Task. can anybody help us to solve this issue that Unpivot task should take the column name dynamically.Thanks,Syed |
|
|
|
|
|
How to change col. dynamically SSIS UNPIVOT TASK