Dear all,

I have created a SQL task which selects a long list of data from a view.

I then add a "Write File" task and include the output from the above SQL task, however the output file is truncated.

Is there a way output the full set of data ? Do I simply need to remove the limit on the "output settings" ?

Is using these 2 tasks the correct method of doing this ?

Thanks


Graham

Yes, you change the limit in Server settings.

---