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 |
|
nili
Starting Member
1 Post |
 Posted - 2009-04-16 : 22:22:02
|
| Hi, I am new to SSIS.I am trying to import a flat file that column numbers are changing. For Example it could be 3 columns or 4 columns, up to 60 columns.I set up a variable that file name could be passed dynamically.What I need is if 3 columns in the file then import 3 columns and if there are 4 , import 4 columns, etc,Thanks for any response |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-17 : 11:17:44
|
| you cant vary metadata dynamically in ssis unless you use script task. i think its better to keep place holders for all the columns using null values and then substitue with values if present so that metadata remains same. |
 |
|
|
|
|
|
Mapping from flat file