October 1, 2013 at 10:19 am
In an SSIS package I am using a Data Flow Task and I am getting this warming:
Warning2Validation warning. Load Daily Folios from NVCORP: {6574291C-EDED-4C84-8E07-FABBCAD8883D}:
Truncation may occur due to retrieving data from database column "ORIGINAL_SRP" with a length of 11 to data flow column "ORIGINAL_SRP" with a length of 3. NVCORP - STAGE - FoliolinkResvRate_STG - Local.dtsx00
But my SP_COLUMNS shows the following for the ORIGINAL_SRP column
TABLE_NAME COLUMN_NAME DATA_TYPETYPE_NAMEPRECISIONLENGTH
FOLIOLINK_RESV_RATE_STG ORIGINAL_SRP 12 varchar 50 50
Any thoughts , why it thinks it's only a length of 3??
October 1, 2013 at 10:45 am
sp_columns shows the length of the column in the database. The error message propbably indicates that the length 3 is in the data flow column in the package. have you explicitly defined it or it has been created automatically following the package (VS) GUI ?
With the Microsoft drivers sometines the data type is determined by a few first rows of the data, i had similar situations when importing from Excel into SQL Server.
Regards,Yelena Varsha
October 1, 2013 at 10:55 am
Thanks for the response, I believe that is the case , originally in the Data Flow I was hardcoding a value of 'UNK' for the field ORIGINAL_SRP, we have now implemented real code for the column :), and it is no longer a 3 column hard code. I would imagine the Data Flow task will work fine when it runs.
I was just not sure if I needed t clear the warning in BIDS prior to putting the code into Production. Any thoughts on that?
Thanks again
Michael-
October 1, 2013 at 11:05 am
I don't know what the particular warnings come up for your package, you have to evaluate the warnings and determine if they are relevant or not.
My advice is to take User or Functional requrements, write Test Cases that are based on the requirements and or specifications and test your package before you release it to production. If all tests pass for a range of conditions, you ask the business to test. If all tests pass then your package is performing according to the requirments and / or specifications. Usually a technical person test based on specifications and the business tests based on the user and business requirements.
After the package is moved to production, test again.
Yelena
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply