 |
Exporting large amounts of Data from SQL
Danny Mehmed (1589 views)
Exporting Large amounts of Data from SQL
If you have ever had an issue transfering large amount of data from SQL you can use the command line tool to solve this problem.
From the command line
#s#bcp [<database_name.>[<owner>].]<table_name> out <csv-file> [/U<username>] [/P<password>] [/
|
 |
DTS, Excel and mixed format columns
Paul Hayman (4078 views)
DTS, Excel and mixed format columns
I recently had a problem DTS importing an Excel spreadsheet which contained columns with mixed text and data values. After a bit of hunting around, I found an extended property IMEX=1. The IMEX=1 property forces everything to text when reading from a source.
|