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 |
raghuigate
Starting Member
5 Posts |
Posted - 2013-05-21 : 07:12:10
|
When Im extracting data from a table to text file using DTS and SSIS there is a difference in file format please help.DTS:@MN789654 ABCD 5555555,Å4DD-E.^%~O6D+zó<¿Ví?e-\VYùrïå¿E=DûûO'o,ó }oôO&¿o*Iíî~E"ùÇy"OíO[Iåæ£è@HƒfSL`²«bSSIS:@MN789654 ABCD 5555555,Å4DD-E.^%~O6D+zó<¿Ví?e-\VYùrïå¿E=DûûO'o,ó }oôO&¿o*Iíî~E"ùÇy"OíO[Iåæ£è@HƒfSL`²«bUsing DTS data is moving to separate row after column delimite(,). |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-21 : 07:16:33
|
it may be that delimiter is not given correctly.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
raghuigate
Starting Member
5 Posts |
Posted - 2013-05-21 : 07:26:26
|
DTS:Vikash please find the setting detailsDTS:File Type: ANSIRow delimiter : {CR}-{LF}Column delimiter:CommaMax characters per delimited column: 255SSIS:Format : DelimitedText qualifier: _x003C_none_x003E_Header row delimiter :{CR}-{LR}row delimiter :{CR}-{LR}Column delimiter: Comma {,} |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-21 : 07:30:00
|
whats _x003C_none_x003E_? where's qualifier set in DTS?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
raghuigate
Starting Member
5 Posts |
Posted - 2013-05-21 : 08:07:37
|
We develop SSIS packages on a 32 bit machine. These packages are deployed on a 64 bits system running SQL2008 R2. When we deploy a package and the package containsa flatfile, it adds a weird text qualifier: _x003C_none_x003E_There no value set to Text Qualifier in DTS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-21 : 08:15:19
|
thats can be a reason. DTS might have interpretted it as a part of delimiter causing the rows to skew------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|