User Profile
KayKay1965
Copper Contributor
Joined 10 months ago
User Widgets
Recent Discussions
SSIS & Raw File Source
i have ssis package writes data to Raw File Desitnaion. in another DF, i am trying to read from same .dat file using Raw File Souce, when i execute getting Error : String too long, The Adapter read a string that was x byte and expected a string no longer than y bytes at offset xxx. This indicate a damaged input file. The file shows a string buffer column too large how do debug this error. checked all the columns size/type same as306Views0likes0CommentsGrouping by date
This is my data set, how to grouping by next occurance of Null Start_Date End_Date 2020-01-15 NULL 2020-01-15 2020-01-15 2020-01-17 2020-01-17 2020-01-21 2020-01-17 2020-01-22 2020-01-21 2020-01-23 2020-01-22 2020-01-24 2020-01-23 2020-01-24 2020-01-24 ---> This End_Date will be End_Date for the Start_Date = 2020-01-15 2020-12-28 NULL 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2020-12-28 2021-01-12 2021-01-11---> This End_Date will be End_Date for the Start_Date =2020-12-28 2021-09-22 NULL 2021-09-22 2021-09-22 2021-09-29 2021-09-22 2021-09-29 2021-09-29 2021-11-12 2021-11-12 ---> This End_Date will be End_Date for the Start_Date =2021-09-22 Final Result result will be like this 2020-01-15 2020-01-24 2020-12-28 2021-01-11 2021-09-22 2021-11-12230Views0likes0Comments
Groups
Recent Blog Articles
No content to show