Invalid character value for cast specification
Oct 5, 2015 · An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
How to Truncate the Data from Excel sheet ..when loading
Sep 19, 2011 · I am loading the data into Excel destination using ssis. Everyday I need to truncate the sheet and reload that fresh.
SSIS Package takes a long time to run - social.msdn.microsoft.com
Jul 28, 2015 · I built my first SSIS package. It takes 25 minutes to run. It pulls 3500 rows from a view (15 columns), converts to Excel data types, then updates one column of values using an …
SSIS Memory - social.msdn.microsoft.com
Nov 1, 2012 · We have a server that has ssis and ssas running, since we use ssis only for nightly loads and need all the memory available for ssas during business hous, how should we …
How to get values from SSIS Object variable?
Dec 19, 2008 · The SSIS Object variable is a generic object, but I have never seen it used as anything other than a dataset -- which is the default behavior that is accessible to you when …
Transaction Property in SSIS Package - social.msdn.microsoft.com
Aug 14, 2013 · Requirement : when the Sequence container failure then Rollback SQL Task succeed ( It means Rollback the Data when Package failure) (note:PC had problem with …
SSIS DB Log files - social.msdn.microsoft.com
May 16, 2016 · I have a 25 GB (and growing ..) log file belonging to the SSIS catalogs DB. I set my retention period to 14 days but still no decrease in size. The SSIS Server Maintenance Job …
SSIS Changing Column Order during Transformation
Feb 11, 2015 · I had this issue, where i developed a SSIS package using SQL Server 2005, my destination is flat file and my column order was rearranging itself. i came up with 2 solutions
Transactions and error handler - social.msdn.microsoft.com
Apr 2, 2012 · Right, I forgot about the NotSupported property. This is a simpler and cleaner solution. I usually don't use the SSIS transactions, as DTC can give quite some issues (most …
SSIS- Error handling in Dataflow - social.msdn.microsoft.com
Jul 16, 2015 · In the SSIS data flow, many data flow components provide an ErrorOutput that allows us to route rows that generate errors or truncation to another component in the data flow.