Ssis698 -

Static file names are fine for a one-off task, but in an automated production environment, they lead to: New runs destroy old logs.

Data is being truncated (cut off) because the destination column is smaller than the source data. ssis698

If the package runs fine in Visual Studio but fails when scheduled as a SQL Agent Job: Static file names are fine for a one-off