GeekZilla

DTS Articles

Exporting large amounts of Data from SQL

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 bcp [<database_name.>[<owner>].]<table_name> out 

DTS, Excel and mixed format columns

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 sour

Tag Cloud