Post reply

something like 'delay validation' property for OleDb destination?

  • March 18, 2010 at 12:42 pm

    #143534

    I have a simple package where i import a text file into a table.

    The text file sometimes has spaces before and after the data for each column, so i have a derived column transformation between the flat file source and oledb destination where I do an RTRIM, LTRIM for each column.

    if I leave the flatFileConnectionManager (on the advanced tab) with the exact column size of my destination table columns, my flat file source fails since the text file coming in has columns that are longer than size i specified (due to the spaces).

    SO, I changed my flatFileConnectionManager with large column sizes that do NOT match the output table column sizes, but the data gets trimmed with the derived column task & everything works fine now.

    What i don't like is that the OleDb destination has a warning symbol on it. Each time the package runs i get a bunch of warnings that the sizes of the columns from the flatFileConnectionManager are not in synchronization with the OleDbDestination columns.

    We are all familiar with the warning, but in my case - I don't want it because I did it on purpose so that the data can flow to my derived column transformation & get trimmed & then get to the OleDB destination with the proper sizes.

    Is there some sort of property that I can set to avoid all of these warnings? kind of like what 'delay validation' property does for tasks that use variables as sources etc. - Meaning that it should wait til the derived column task does its thing and then it would be happy, so the warnings should not be displayed.

    if this is unclear, pls let me know what I should clarify.

  • March 19, 2010 at 5:01 am

    #1136592

    You could add a Data Conversion component that converts all the columns to the length of the OLE DB Destination columns. That should get rid of all the warnings.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 19, 2010 at 8:02 am

    #1136734

    That worked. Thank you!

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

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