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 |
|
learntsql
524 Posts |
 Posted - 2012-05-08 : 01:33:51
|
| Hi All,I am using SSIS package to load data from excel sheet to sql tableI am redirecting the error rows to some other error table.this error table contains all the columns as nvarchar datatype where as actual table contains like decimal and some other datatypes.Now my requirement is how to process these error records and load into actual table.Please guide me.TIA. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-05-08 : 02:29:04
|
write a stored procedure to clean up the data in the error table and then insert into the actual table.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
error records processing and loading to table?