Importing fixed length file to SQL server

[geekfromindia]

Hi, Whats the best way for importing a fixed length file to SQL Server 2005. Currently I am using DTS. Are there any better ways to achieve this??

Keep DotNetting!! GeekFromIndia

[Wendelius]

It's hard to say what's a better way since you don't specify what is it that you are not satisfied with in DTS. However, another alternative could be using bcp (Bulk Copy Program) from command line or SqlBulkCopy class from C#. Mika