I am trying to import a large file into SQL server that is | delimited.
I know basically nothing about the data, I just want to get it imported.
When I go to Database->tasks->import I use the advanced option to suggest types, and provide padding.
The problem is that that routine does not go through the whole file, even when I specify an absurly large number of rows (1000000000), and so I am constantly getting tructation->error, change the types, restart the import etc errors.
Is there a better way to do this?
Note: The file is not on the same machine as SQL Server