July 19, 2010 at 8:55 pm
Before i posted in wrong section the same post....
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 21, 2010 at 12:42 pm
Just a suggestion. Each article at SSC has a link at the bottom saying "Join the discussion" where questions/views/suggestions specific to that article are discussed. I guess, it would be easier for the author to answer your question if you post the question there or a link to this post in that discussion.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply