Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but not human.

I...

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

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

Hi sudhirnune

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

Hi sudhirnune

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

Cheers,

sudhirnune (8/24/2012)

---

Hi All,

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

Hi SubhashK

Please take a look at this topic: Problem Importing CSV Files into SQL 2008... It may be the way to do it.

Cheers,

Na1774

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

Hi Na1774

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

Hi Cuclasi,

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

Hi Raghavender

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)

1. Check...

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

Hi Komal

You will find another example on this topic: Problem Importing CSV Files into SQL 2008...

Cheers,

Hi aveerabadran

Please take a look at this blog: How do I disable all logging on my packages?

Cheers,