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 |
|
kunaaldesai
Starting Member
36 Posts |
 Posted - 2009-06-23 : 21:26:39
|
| Hello Guys, I have been trying to import a table from CSV flat file to SQL server using SSIS services and when I import it without any edit in mapping then it works fine but when I try to edit mapping like changing the destination column name or datatype or something else then it gives me an error.Does anybody know what I am doing wrong??KunalAnything |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-24 : 12:29:53
|
| what's the error you're getting? it may be that there are some incompatibility b/w source and destination data types |
 |
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-06-24 : 12:53:45
|
| don't thik that it is because of datatype because when I don't change the table name and destination column names, it works fine and imports data with default column names( column 0, column 1) etc.The moment I change names it breaks. So datatypes stay intact the only hting I change is names.Anything |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-24 : 12:55:10
|
| names of columns of tables you mean? |
|
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-06-24 : 13:24:36
|
| Oh yesAnything |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-24 : 13:39:16
|
| do you mean you're trying to rename the columns in your destination table? you cant do that from import export task. the renaming should be done by using sp_rename stored procedure outside of dts |
|
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-06-27 : 18:17:51
|
| Hi Vishakh, I am sorry for the late reply. Well, I was using import/ export wizard to import the records and I wanted to change the mapping of the columns in the process itself. But as you said , the wizard did not support that facility, instead I used source, transformation and destination tools to do the procedure and it seems to be working fine.Thank you very much for your feedback.Kunal[/b]Anything |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-28 : 00:43:14
|
| welcome |
|
|
|
|
|
|
SSIS import doesn't allow edit mapping