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 |
|
Haarish
Starting Member
30 Posts |
 Posted - 2009-04-17 : 05:03:57
|
| Hi All,I have a CSV file that has a set of columns populated. I tried importing this file to the DB with an SSIS package. The package works fine but there are two columns that will always have values but these are being returned as NULL in the Db. I have a derived column task betwen the source and the destination that trims the columns. I set a metadata viewer between the source and the derived column task only to find out that the values in these colummns have been padded with the string '<LONG TEXT>'. Any idea why this would be happening and how I could avoid these in the future?Thanks,Haarish |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-17 : 11:15:11
|
| then that might be problem with data existing in source. you could remove this part in derived column task using substring and then only populate reqd part in destination. also make sure your transformations are all mapped correctly. |
 |
|
|
|
|
|
Import text file columns