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 |
|
valedaw2
Yak Posting Veteran
50 Posts |
 Posted - 2011-09-27 : 09:11:10
|
Hello,I am trying to import a fixed format file with several fields, of which 3 are encrypted, then append data and export the file back out in fixed format. I am creating a view and using BCP to export the file, because 2005 does not export fixed format too easily. The problem I am having is with the encrypted fields. The value seems to change and the length of the field too, even though I am not processing the field. Is there something I need to do in the import and export to get the same results as the input? Any help would be appreciated. I have a deadline of today....... |
|
|
valedaw2
Yak Posting Veteran
50 Posts |
Posted - 2011-09-28 : 08:25:06
|
| Never mind, someone here found the answer. I needed to add -t after the out file |
 |
|
|
valedaw2
Yak Posting Veteran
50 Posts |
Posted - 2011-10-28 : 12:41:46
|
| The -t did not work. It appears that the data is not importing into SQL 2005 properly. Has anyone got an idea of what to do to import and export this data, without changing its value? |
|
|
|
|
|
|
Import and Export encrypted field