Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
velnias2010
Posting Yak Master
125 Posts |
 Posted - 2014-06-19 : 08:37:54
|
| Trying to export a SQL Server 2012 table to CSV file, with tab delimitedUsing the Export wizard it completes it no problem but behaving as expected,Lets say I have 3 Columns address1 NVARCHAR(50) address2 NVARCHAR(50) address3 NVARCHAR(50)It is exporting it is doing Column Width 50 (with value) |tab| Column Width 50 (with value) |tab| Column Width 50 (with value) |tab| I was hoping for Actual Value Length |tab| Actual Value Length |tab| Actual Value Length |tab| |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-06-19 : 11:09:05
|
| Export wizard generates SSIS packages with limited options. You probably want to build a custom package using BIDS (before SQL Server 2012) or SSDT. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-06-21 : 05:15:15
|
| you need to make file type as delimited rather than fixed width in the properties. Then width will depend on actual value length rather than always being fixed on max length.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SQL Server Export Tab Delimited, Column Value only