hi, I have a problem with a flat file and a table
I have a flat file with 5 columns and in the table I have 30 columns and they all are (not null)
I cannot leave other columns in target for which it throws mistake, have to insert something, since as I insert information in the demas columns?
Since I can solve this problem?
helps please
TheViewMaster wrote:
Use a derived column transform to create default values for each column not in text file
Thank you very much, I work perfectly
|||Glad to be of assistancePlease mark my previous post as an answer if you have a chance - need to make it to top asnwerererers

No comments:
Post a Comment