Dear Experts, I am doing an export from AD for all users, computers and Groups to 3 different CSV files and from CSV filess to 3 different SQL Tables so that Reporting will be easier through SSRS. Till date everything was working fine but suddenly, I noticed that the SSIS packages are failing since past 1 month with the below error 1: Error for Users SSIS package: Source: Importing Data from AD_Users CSV file to AD_Users SQL Table AD_Users CSV File [1] Description: The column delimiter for column "dlMemSubmitPerms" was not found. End Error Error: 2011-07-02 01:45:34.55 Code: 0xC0202092 Source: Importing Data from AD_Users CSV file to AD_Users SQL Table AD_Users CSV File [1] Description: An error occurred while processing file "D:\ActiveDirectoryCSV\AD_Users.csv" on data row 1491. End Error Error: 2011-07-02 01:45:34.58 Code: 0xC0047038 Source: Importing Data from AD_Users CSV file to AD_Users SQL Table Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "AD_Users CSV File" (1) returned error code 0xC0202092. The component returned a ... The package execution fa... The step failed. 2: Error for Groups SSIS package: Source: Importing Data from AD_Groups CSV file to AD_Groups SQL Table AD_Groups CSV File [1] Description: The column delimiter for column "publicDelegatesBL" was not found. End Error Error: 2011-07-02 01:45:34.55 Code: 0xC0202092 Source: Importing Data from AD_Groups CSV file to AD_Groups SQL Table AD_Groups CSV File [1] Description: An error occurred while processing file "D:\ActiveDirectoryCSV\AD_Groups.csv" on data row 103. End Error Error: 2011-07-02 01:45:34.58 Code: 0xC0047038 Source: Importing Data from AD_Groups CSV file to AD_Groups SQL Table Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "AD_Groups CSV File" (1) returned error code 0xC0202092. The component returned a ... The package execution fa... The step failed. I dont know what went wrong and what is the cause. Can some one please guide me. Thanks!Uttam Kumar Sahoo

Errors are clear, you have BAD data rows in Users csv (row 1491 ), and groups csv ( row 103) maybe bad rows be few rows before than the exact row number, look at the csv file , maybe there are extra delimiters or delimiter in values or few delimiters. you should find bad thing there which cause failure and it should be related to delimiter as it seemshttp://www.rad.pasfu.com

Thanks a lot Reza. Yes, I manually removed the erring rows from the csv file and then if I run the SSIS package, then it will succeed. But my question is, if it was working till date without any issue what happened suddenly. From AD prespective, I can see that those user or Group has not been modified recently..which means the data is same as it was before..so I am suspecting SQL..but not sure what is the cuase.. I am really clueless!Uttam Kumar Sahoo

there should be a change. because as you see package was working before, did you looked at bad data rows carefully? maybe they contains new or updated data which caused this problem. by the way, you can CONFIGURE ERROR OUTPUT on the flat file source and redirect bad data rows to another flat file destination for future similar issues, with configuring error output package will redirect bad data rows in good mode and doesn't fail.http://www.rad.pasfu.com

Hi, Definitely there should be a change in the record. you can redirect the error output to an output file for more analysis. Best regards, SenwaBest regards, Sengwa

You could also use data viewers to observe the data in the bad rows.Happy to help! Thanks. Regards and good Wishes, Deepak.