No errors in error log and event viewer.

i noticed the user used "ALTER LOGIN" command to change default database. Is there any way we can prevent "ALTER LOGIN" execution? I tried with "DENY ALTER LOGIN"...

Thank you.  Will take a look at it.

Thanks Everyone.  I have set the Datatype to VARCHAR(37) at destination and able to resolve this issue.

i have set source file column data type as DT_WSTR (50) and destination table (SQL) data type as DATETIMEOFFSET.  i have tried using Derived column to convert to datetimeoffset and...

The source and destination tables are same structure.  Source does not have refrential integrity key defined.  If i understand correctly, you are suggesting to use Data Flow task to process...

I wont be able to perform as set because i have to keep track errors for each row (expected errors likely be Foreign Key errors).  Will SSIS perform better through...

I was using the for each loop container to process the files in the folder and that was causing the error to populate multiple times.  It took a while to...

Hi Andrew
I am not able to attach the code and other screen shot.  I have enabled the DataViewer and noticed that the error row in Source Flat file is...

Thank you and it seems to be the solution. However, for now we have increased the disk capacity and will look into it later when we run into issues...

Thank you. It works for me.

This works from SQL 2008 R2 onwards. But in SQL 2008 it doesnt work.

Thank you! I was looking for something like this.

Thanks