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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-11-03 : 12:21:46
|
| I am importing a .csv file into a table in sql server using ssis.in dataflow, there is a flat file connection task and an oledb destination.The table has float columns. The ssis gives the following error:[OLE DB Destination [54]] Error: There was an error with input column "One Week" (88) on input "OLE DB Destination Input" (67). The column status returned was: "The value could not be converted because of a potential loss of data.".How can this be solved please?. Should I use a convert task if there is one?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 12:32:02
|
| you can use data conversion task or derived column where you cast it to accurate numeric data type------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-04 : 08:43:12
|
| It seems to be easier to do the conversion inside the stored proc.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-04 : 12:54:48
|
quote:
Originally posted by arkiboys
It seems to be easier to do the conversion inside the stored proc.Thanks
yep...thats true. if you've ability to do that by all means you can do it there------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
convert datatype