1. Always check the file for a delimiter
2. It is safer to upload to access database before taking it directly to the SQL server
3. It is safer to use pipeline '|' as a delimiter rather than any other symbols
4. Always check the row count before and after upload. This can be done using 'Ultra edit'
5. Match the columns in the source and the destination
6. .dat can also be converted to a text file by opening with a notepad and saving it as .txt file for easy handling
7. Make all the data types as text format to solve data conversion issues
2. It is safer to upload to access database before taking it directly to the SQL server
3. It is safer to use pipeline '|' as a delimiter rather than any other symbols
4. Always check the row count before and after upload. This can be done using 'Ultra edit'
5. Match the columns in the source and the destination
6. .dat can also be converted to a text file by opening with a notepad and saving it as .txt file for easy handling
7. Make all the data types as text format to solve data conversion issues
No comments:
Post a Comment