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 |
|
nicki_assumption
Yak Posting Veteran
69 Posts |
 Posted - 2005-07-14 : 12:42:55
|
| Hi- I would like to import tables from Access into SQL Server. I set up a DTS with the import wizard. I want the new table to have the datatype varchar b/c some of my stored procedures seem to fail if the datatype is nvarchar. I guess from Acess, automatically, nvarchar is the datatype. Is there a way in the DTS that I can convert the data to varchar? Is this more easily done in the query once everything is over? Thank you. Should I include anything else? I'm not sure how to get a text version of the dts, it's all objects to me or I would copy and paste it. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-17 : 19:18:51
|
| If you create the DTS without using the wizard (perhaps even with the wizard-I can't recall), you have the chance of specifying the CREATE TABLE statement to reflect what you want. It will normally create it for you automatically, but you can go in and change the data types. But I think you should investigate why your SP's are failing first. Changing the datatype should be a last resort IMO.Cheers,Tim |
 |
|
|
|
|
|
Converting to varchar rather than nvarchar in DTS