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 |
|
nickboon
Starting Member
2 Posts |
 Posted - 2009-01-21 : 05:43:28
|
| hai,i want to import some csv file into a db already structured, ok no problem but i want to say when im importing the file that the day, month and year columns are merged together and imported in 1 column named date (witch i already made.) can somebody tell me how to do this?thanks and kind regards Nick Boon |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-21 : 07:19:06
|
| You can define a VB transformation in DTS , if thats what you are using to import your data. Or an easier way would be to have it as a computed column. Or, You could import it to a temptable and then perform the insert to your actual table. |
 |
|
|
nickboon
Starting Member
2 Posts |
Posted - 2009-01-21 : 07:36:48
|
i found the right solution i use a dirived column data flow transformation.thanks anywayquote:
Originally posted by sakets_2000
You can define a VB transformation in DTS , if thats what you are using to import your data. Or an easier way would be to have it as a computed column. Or, You could import it to a temptable and then perform the insert to your actual table.
|
|
|
|
|
|
|
csv merge col. import