Appending to File - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

Mike Csete
Paid support Topic Starter

2021-09-28T21:25:05Z

I'm trying to append data from a SQL script into an existing file that was created from a previous step in a job. I do not want to create a new file, so I'm adding to the new file that was just created. The issue is the when I use the "Append to file" check box, it outputs the data to the file but it's starting on an existing row. It does not start on a new row. For example:

The First task outputs this to a file:
StudentLastName, StudentNumber, HomeRoom
Smith, 12345, Blue
Johnson, 54321, Blue

Next task outputs Green HomeRoom to the existing file:
StudentLastName, StudentNumber, HomeRoom
Smith, 12345, Blue
Johnson, 54321, BlueJones, 78941, Green
Harmon, 54891, Green

What am I missing? I need it to look like:
StudentLastName, StudentNumber, HomeRoom
Smith, 12345, Blue
Johnson, 54321, Blue
Jones, 78941, Green
Harmon, 54891, Green

Edited by user 2021-09-28T21:26:33Z | Reason: Not specified

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Joey S
Paid support

2021-09-29T19:14:23Z

I am not a SQL expert but I assume you can add a carriage return into the results you are trying to write out
OR
you can simply have a task before the SQL task that writes a line feed or carriage return in to the file

This is my fake SQL task writing some numbers as output

before

After

Edited by user 2021-09-29T19:15:00Z | Reason: Not specified

Mike Csete
Paid support Topic Starter

2021-09-30T15:13:06Z

Thanks for the suggestions Joey. I added a write to file task with a blank line in between the Read and Output task, and it gives me this:

StudentLastName, StudentNumber, HomeRoom
Smith, 12345, Blue
Johnson, 54321, Blue

Jones, 78941, Green
Harmon, 54891, Green

Which made me laugh because that's the behavior I feel the append to file task should be working (i.e.starting on a new line).

I did not want to modify the SQL script, but I can try that as a last resort.

Joey S
Paid support

2021-09-30T16:00:54Z

I have experienced the same thing and it is kind of maddening

There is usually some sort of "trick" you have to play in the output of the sql run

Something in there should solve it. Try No Line Break maybe?

This post might help the SQL script if tweaking the VC output settings does not
https://stackoverflow.co...-varchar-nvarchar-string

Example:

DECLARE @text NVARCHAR(100)
SET @text = 'This is line 1.' + CHAR(13) + 'This is line 2.'
SELECT @text

This prints out the following:

This is line 1.
This is line 2.

Support
Official support

2021-10-12T18:08:33Z

Did you manage to find a solution for this, Mike?

Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!

Mike Csete
Paid support Topic Starter

2021-10-15T14:37:45Z

Originally Posted by: Support

Did you manage to find a solution for this, Mike?

Unfortunately, I did not. The more I looked into it, it seems like it's adding the line break at the bottom of the newly appended data rather than adding it to the top, which explains the behavior I'm seeing. So even if I manage to add a line break before the new data, I'll have a blank row on the last line of the file.

yiroti yiroti
Newbie

2026-10-19T08:46:45Z

Is any person here with facebook as well as want to friend myself? What exactly are your own twitting names, it is a excellent submit by the way. Also is there a good RSS feed I could not find it?macarons

vayab4 vayab4
Newbie

2026-10-19T15:49:59Z

제주출장마사지 셀럽의 코스와 가격, 방문 예약 방법을 확인하세요. 제주시·서귀포시·애월·중문 등 지역별 상담과 숙소 출입, 예상 도착 시간, 제주출장안마 현장 결제 기준을 안내합니다. 제주출장마사지

fepef58396 fepef58396
Newbie

2026-10-22T10:01:59Z

You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. situs toto

fepef58396 fepef58396
Newbie

2026-10-24T10:10:53Z

#10

I {keep|cling on to|carry on} listening to the {news|reports|newscast|news bulletin|news update|rumor|news broadcast} {speak|talk|lecture} about {getting|receiving} {free|boundless} online grant applications so I have been looking around for the {bes… There is apparently a lot to identify about this. I think you made certain good points in features also…. ducted air con Canberra

vayab4 vayab4
Newbie

2026-10-24T12:32:58Z

#11

I’d must talk to you here. Which isn’t something Which i do! I love to reading an article that can make people believe. Also, thanks for allowing me to comment! TOGEL ONLINE

Azhar Khatri
Newbie

2026-10-25T07:31:36Z

#12

There couple of fascinating points with time in this post but I don’t know if these center to heart. There’s some validity but I am going to take hold opinion until I explore it further. Excellent article , thanks and we want more! Added to FeedBurner likewise bandar slot

fiheye fiheye5431
Newbie

2026-10-25T07:44:55Z

#13

My goal is to get in better shape so I can participate in all activities when I shaperone the class trip to the nature center. ufabet369

vayab4 vayab4
Newbie

2026-10-25T10:58:42Z

#14

Your posts continually include much of really up to date info. Where do you come up with this? Just declaring you are very resourceful. Thanks again coloksgp

Azhar Khatri
Newbie

2026-10-26T07:32:15Z

#15

you are actually a good webmaster. The web site loading pace is incredible. It kind of feels that you’re doing any unique trick. Moreover, The contents are masterwork. you’ve done a great task in this topic! betflix1688

fiheye fiheye5431
Newbie

2026-10-27T09:04:52Z

#16

This sort of wanting to come to a difference in her or his lifestyle, initial generally Los angeles Excess weight weightloss scheme is a large running in as it reached that strive. weight loss naza24

yiroti yiroti
Newbie

2026-10-28T11:33:01Z

#17

I hate my boss. So during the spare times, I am quite down and dumbed from the repetitive tasks. Your posts give my brain some needed excercise. Thanks!meškiai

fepef58396 fepef58396
Newbie

2026-10-28T13:01:51Z

#18

포항오피 검색과 관련된 온라인 정보 확인 방법을 알아보세요. 광고 문구와 일반 정보의 차이, 후기 검증 기준, 공공기관 자료 활용 방법을 정리했습니다. 포항오피

vayab4 vayab4
Newbie

2026-10-28T15:40:22Z

#19

구미 지역 마사지 시설을 알아볼 때 도움이 되는 안내입니다. 서비스 종류와 이용 요금, 예약 방법, 위생 관리 및 방문 전 확인사항을 살펴보세요. 구미오피

vayab4 vayab4
Newbie

2026-10-29T15:58:15Z

#20

부산 지역 마사지 서비스의 이용 안내와 관리 프로그램에 관한 주요 정보를 확인할 수 있습니다. 부산토닥이

fiheye fiheye5431
Newbie

2026-10-31T06:21:04Z

#21

Please let me know if you’re looking for a writer for your site. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d love to write some material for your blog in exchange for a link back to mine. Please shoot me an email if interested. Regards! 123Movies Online

fiheye fiheye5431
Newbie

2026-10-31T11:19:02Z

#22

Many people target you should distinct foot work a long time before writing. Are going to be probable for you to additional desired short article in doing this. hargatoto

Azhar Khatri
Newbie

2026-10-31T12:01:00Z

#23

if the buffalo in my head could speak german i would not know a god damm thing. What i do know is that the language of art is out of this world. slot dana

fiheye fiheye5431
Newbie

2026-11-02T11:36:34Z

#24

You are my inhalation , I own few blogs and rarely run out from to post : (. gpt pro代充

fiheye fiheye5431
Newbie

2026-11-03T15:48:20Z

#25

경기도 성남출장마사지 셀럽의 코스와 가격, 자택·호텔 방문 상담, 선입금 없는 예약 및 현장 결제 기준을 확인하세요. 방문 가능 여부와 예상 도착 시간은 주소와 성남출장마사지