I have problem try to test out the CaseStudy program.

when I try to run the code on the SQL command
EXEC usp_BankBatch_Add @BankBatchID OUTPUT, @BankBatchNbr, @DepositDate, @ReceivedDate, @BatchTotal, @BatchItems, @FileBytes, @FullFilePath, @ImportType
I got the following error:

Error: 0xC002F210 at Execute SQL Task to Add Bank Batch Hdr, Execute SQL Task: Executing the query "EXEC usp_BankBatch_Add @BankBatchID OUTPUT, @BankBatchNbr, @DepositDate, @ReceivedDate, @BatchTotal, @BatchItems, @FileBytes, @FullFilePath, @ImportType " failed with the following error: "String or binary data would be truncated.
The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task to Add Bank Batch Hdr
Warning: 0x80019002 at For Each Lockbox File: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Information: 0xC002F30E at File System Task Error Folder, File System Task: File or directory "c:\casestudy\lockbox\error\2007123020472031200000 0286.txt" was deleted.
Warning: 0x80019002 at Sequence of Lockbox Processing: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Warning: 0x80019002 at CaseStudy_Load: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "CaseStudy_Load.dtsx" finished: Failure.


Any idea?

Hi dw60025,

   I communicated with Douglas Hinson (who authored the case study). His response:

"Sounds like the error is being generated from SQL Server not SSIS. Based on the fishy looking file name I'd suspect they attempted to rerun processed files back through the program, but the max filename size is 50 char (100 Unicode chars). Have them either change the filenames to be smaller or alter the column size in the data table BankBatch for FullFilePath to something like NVARCHAR(1000)."

Hope this helps,
Andy

Andy Leonard

Also,
the create table script for the BankBatch table has an error for the ImportType column. It should be [ImportType] [char](10) NULL, not [ImportType] [char](1) NULL,.