i want to use the dynamic task properties in a dts task. I want to use a
datafile. i would like to know what the end of line delimiter is.
thanks

There isn't a delimiter as far as the task is concerned. It reads the whole
file and that is the value used for the assignment.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Aron E. Tekulsky" <atekulsky (AT) iie (DOT) org> wrote

so then how does it know the end of one item and the beginning of another ?
how does it know to go to the next line ?
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Aron E. Tekulsky wrote:
It doesn't care. The Data File assignment takes the entire file,
including any line breaks if present, and assigns all the content to the
property selected. There is no need for line breaks. This is not like a
structured file which contains multiple values for several assignments.
One file sets one property.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

Dynamic task = 1 value (per line item in properties)
Sounds like you may prefer an ODBC to txt using fixed width or other
delimiter.