Problem in transform data task whlie generating text files.

  • Hi all,

    I am generating text files from database tables.

    When number of columns are less then 15 i am able to define cloumns in destination text file but when number of columns in table is more then 15 task is not able to generate columns in destination text file.

    Thanks In Advance.


    Kind Regards,

    Chintak Chhapia

  • You should have not problem to create text files with more than 15 columns.

    Maybe if you create a dts pkg with 15 columns the first time and you want to include more columns later you probably wont be able to do it until you inlcude this columns in source part under transformation task.

    Rgds

    JFB

  • I have found the solution of problem.

    If you have installed service pack 3a the dts designer gives error.

    Solution : install service pack 4 fo sql server.


    Kind Regards,

    Chintak Chhapia

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply