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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-11-13 : 18:55:36
|
| Hi thereWe have 2 types of CSV flat file (37 columns VS 15 columns). From the user perspective, they treat this as the same type file CSV but the system will identify this as 2 seperate entities.First of all, we are creating a package with 37 columns maximum. But what found is that I need to reconfigure in the Configuration Manager to allow certain size cause the default sampling is not good enough - string[DT STR] - 50 and we have to set that to string[DT STR] - 128. It seems that this thing is generated when you point the specific file but if the file is so dynamic how do we hard coded this to specific size that we want string[DT STR] - 128.Thanks |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-11-13 : 22:22:06
|
| Actually, what we found that if we setup to 37 column one, the set of data that has only 15 column will be in the rest of column 16, 17, 18 etc etc.Cause I can see the original records is about 12,000+ but now only 4000+ and I can see that the column 16-37 has been filled up wit with some data ?!!?Any ideas how to stop this?!?! |
 |
|
|
|
|
|
Imported 2 types of Flat File using SSIS