Viewing 15 posts - 1 through 15 (of 127 total)
Brandie Tarvin (2/25/2015)
March 8, 2015 at 1:48 am
A lot of good reading, everything started by T4FF who asked directions to implement something simple, like this:
The thread evolved with several suggestions, routes, ideas, etc, it was looking like...
December 7, 2012 at 4:41 am
Nothing wrong with the previous two suggestions, but I rather prefer to check for NULL first, and TRIM() the column when checking for the double dashes, like below:
(ISNULL (civilianYears) ||...
August 30, 2012 at 1:42 am
It should work for you as explained, I did a test to prove it, let me explain what I did.
1. Found an Address table with 16,358 rows.
2. Modified 3...
August 30, 2012 at 1:18 am
If you are hard coding "STRING\32" in your FINDSTRING tests, then you should mask the back slash as well, the string "STRING\32" is interpreted as "STRING32" because the back...
August 28, 2012 at 8:53 pm
August 27, 2012 at 12:22 am
We are using FINDSTRING Function in one of Data flow Derived Column (Component), It work Fine for Symbols like '&','%' and ' (Single Quote)
Where as we need...
Please take a look at this topic: Problem Importing CSV Files into SQL 2008... It may be the way to do it.
July 16, 2012 at 8:48 am
I changed my package moving the flat file collecting the errors to the target OLE DB Destination component, it works, let me explains what I did:
1. Create the [Person].[Address] table...
July 14, 2012 at 7:18 pm
I tried to replicate your problem with locally; I just created a very small package reading the [Person].[Address] table from the AdventureWorks database, forcing error by shortening its columns...
July 13, 2012 at 9:16 pm
The whole idea should work in Sql 2005, the only drama is with the script code, It is written with C# and you need to convert it to Vb.Net...
July 12, 2012 at 8:43 am
As suggested by Rythmk you have to check your connection manager and data sources; you should follow these validation steps (the bullets numbers refer to the attached images)
July 12, 2012 at 8:28 am
My advice is similar to the one given above; you should add 3 data viewers as shown in the figure below.
If you don't know how to add a data viewer,...
July 11, 2012 at 9:46 am
You will find another example on this topic: Problem Importing CSV Files into SQL 2008...
July 10, 2012 at 11:18 pm
Please take a look at this blog: How do I disable all logging on my packages?
July 10, 2012 at 11:06 pm