July 19, 2010 at 4:09 pm
This is my first post if there are any thing wrong in my post just let me know...
Actually my goal is to grab filename automatically ....So i have used http://www.sqlservercentral.com/articles/SSIS/67871/ article for creating this one when i am executing i am getting these errors
[Derived Column [34]] Error: The "component "Derived Column" (34)" failed because truncation occurred, and the truncation row disposition on "output column "FileName" (47)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Derived Column" (34) failed with error code 0xC020902A while processing input "Derived Column Input" (35). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
-----------------------
I thought some length problem in derived column and itry to change length in derived column and it was not allowing me to change in derived column. So i use data conversion and make the length as 100 because my destination column name is Filename nvarchar(100)
So is there any suggestions for me....
Advance Thanks for every one.....
July 20, 2010 at 2:32 am
This was removed by the editor as SPAM
July 20, 2010 at 10:26 am
Thank U somuch stewart...It works out....Thanks once again for ur help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply