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 |
|
Code
Starting Member
4 Posts |
 Posted - 2009-02-16 : 12:34:44
|
I modified a data feed file for one of our customners a few weeks ago, and now they are having some hex ‘00’ (low values) in the application when they load the file (screen shot below). Do you have any idea why this might be happening and how I can fix it? I’ve done a bunch of research on the web, but nothing I’ve tried seems to work. I execute my script in server management studio, save the file as text, and then FTP the file to the client.  |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 12:40:28
|
| what is text qualifier while importing? |
 |
|
|
Code
Starting Member
4 Posts |
Posted - 2009-02-16 : 12:54:40
|
| I have no clue. I can ask them if that will help you. This project was just thrown into my lap, and I have no exposure to the type of system they're loading data into. I was given a pre-existing script, made a few changes to it, and now the low key values this is happening. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 12:59:58
|
| How did they import to SQL Server? |
|
|
|
Code
Starting Member
4 Posts |
Posted - 2009-02-16 : 14:15:08
|
| They are loading it into an IBM Host into a sequential flat file |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 14:17:22
|
quote:
Originally posted by Code
They are loading it into an IBM Host into a sequential flat file
Is this SQL Server related question then? |
|
|
|
Code
Starting Member
4 Posts |
Posted - 2009-02-16 : 14:40:27
|
| I'm aquiring the data from a SQL2005 DB, and then giving it to the client to load into their IBM machine. I'm wondering if there is somthing I'm doing on my end that would generate the low key vales on their side. |
|
|
|
|
|
|
Low key values ('00') HELP!