none
Header in flat file destination (ssis)

    General discussion

  • Hi

    I am creating a header in the flat file destination which has some hard coded values and record count which will get its value from a variable assisgned to a row count transformation in the package.

    There is no problem in hard coded value but when i try to get the value of record count, i always get zero.

    This is how i am doing it.

    In the flat file destination, when we open flat file destination editor, i hard code the values which i want in the HEADER itself right there in the editor.

    For the record count, i go properties of the flat file and select expression. In the expression editor, in property, i am selecting 'HeaderRowDelimiter' and drag that variable in the expression box.

    Let me know if there is any suggestion.

    Thanks

    Friday, February 10, 2012 12:24 AM

All replies