June 27, 2005 at 12:15 pm
Does anyone know how DTS determines the default column formats for the DTS import wizard when you are importing a text file, or csv file? Is there a way to set the default column data type to never use an nvarchar, nchar, or ntext field?
Gregory A. Larsen, MVP
June 27, 2005 at 4:34 pm
Greg,
We had a discussion lst week at
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=192943#bm193675
that linked server transforms some data types. I researched ad it appears when you use Linked server it uses OLEDB and as a result, OLEDB data types. DTS Wizard is a front end that generates VB code. The connections that are used is OLEDB to SQL Server and a selected driver for a text file. Do you think that default data type of the column may be specified by a driver that you select for connection?
Yelena
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply