I just execute a package and it took about 12 minutes which I didn't expected. when I look @ the report I found this.

DFt_Load_Tempa: Warning: Truncation may occur due to inserting data from data flow column "ac" with a length of 120 to database column "ac" with a length of 3.

is this may be one of the reason for the slow running package? Help me out.

• Moved by Olaf HelperMVP 13 hours 15 minutes ago Moved from "Database Engine" to a more specific forum

DFt_Load_Tempa: Warning: Truncation may occur due to inserting data from data flow column "ac" with a length of 120 to database column "ac" with a length of 3.

is this may be one of the reason for the slow running package? Help me out.

The message is clear you are trying to insert data of length 120 into column having maximum length of 3. There can be many reason. Why are you trying to insert data of length 120 into column having length just 3

Hi Eldana,

Just as Shanky_621 said, the warning message is about date truncation occurs when loading data to database. As per my understanding, this issue wouldnt be related to the performance issue.

As to the performance issue, please refer to the following tips:

• How many data that loading to the database? If you are trying to load a large amount of data, we can choose Table or view-fast load from a drop down if data access mode is Table or View in the OLE DB Destination Editor. Because Table or view-fast load is the fastest way to load data to destination. It internally uses the bulk insert statement to send data into the destination table. Also we can add Conditional Split Transformation build some parallelism into the common data flow that directly load data from OLE DB Source to OLE DB Destination.
• SSIS relies heavily on buffer. A set of records are read into the buffer, and from buffer they are written to the destination. So we can change two properties DefaultMaxBufferRows and DefaultMaxBufferSize to improve the performance.

Reference:
http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server
http://svangasql.wordpress.com/2012/04/10/simple-tips-to-speed-up-your-ssis-data-flow/
http://www.developer.com/db/top-10-methods-to-improve-etl-performance-using-ssis.html

Thanks,
Katherine Xiong

How many warnings did you get? If you're talking a lot of rows and all generating the warning, then it can certainly slow down the process... it takes time to insert the warnings