Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 30th, 2007, 05:03 PM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error running CH 19 case study.

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?
  #2 (permalink)  
Old January 2nd, 2008, 07:58 AM
Wrox Author
 
Join Date: Sep 2007
Location: Farmville, VA, USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #3 (permalink)  
Old April 2nd, 2009, 10:18 PM
Registered User
 
Join Date: Mar 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error running CH 19 case study

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,.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error ch 19, opening form, adp-file vitmoss2 BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 0 October 4th, 2008 05:09 AM
Ch13 Case Study 2 alecwood BOOK: Beginning Access 2003 VBA 0 October 18th, 2007 05:40 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.