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 |
|
Chinni
Yak Posting Veteran
95 Posts |
 Posted - 2008-09-24 : 12:32:56
|
| here is the expression"/c copy \"" + @[User::FinalFile] + "\"+\"" + @[User::DestinationFile] + "\" \"" + @[User::OutputFile] + "\""/c copy "C:\Header.txt" + "C:\footer.txt" "C:\DataFile.txt"In the Datafile after append is done I am getting a symbol small square(i guess space) at the end of the fileT:000000048I would like to remove that........how can I do that ...any suggestions ?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:11:09
|
quote:
Originally posted by Chinni
here is the expression"/c copy \"" + @[User::FinalFile] + "\"+\"" + @[User::DestinationFile] + "\" \"" + @[User::OutputFile] + "\""/c copy "C:\Header.txt" + "C:\footer.txt" "C:\DataFile.txt"In the Datafile after append is done I am getting a symbol small square(i guess space) at the end of the fileT:000000048I would like to remove that........how can I do that ...any suggestions ??
try with replace. try replacing CHAR(13),CHAR(16) |
 |
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-24 : 13:40:33
|
| sorry where can I added this?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 13:41:19
|
quote:
Originally posted by Chinni
sorry where can I added this??
try adding this inside a derive column task. |
|
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-24 : 15:44:48
|
| instead of appending footer to data file......i changed the scipt such that footer is also aded in same file......intead footer in some other file appending to this file....every thing in one file..............when we append that space is default |
|
|
|
|
|
|
Append files space at endof append SSIS