I have a very basic extract in which data is coming from SQL Server and being exported to a tab delimited text file. For some reason, in the file many of the columns are off (ie they'll be shift over one too far or not at all). What I think is happening is that SSIS is not generating a tab for columns that are blank or null when it should. Has anyone experienced this? If so is there a recommended solution?
If you use a different delimiter, does it work OK?
Your hypothesis that SSIS is not generating delimiters in certain circumstances fails to explain why the columns would ever "shift over one too far." Could your source data contain tabs?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply