As Elliott suggests, this is really a T-SQL performance question.

Unless you are suggesting that the proc runs more quickly when executed in SSMS than in SSIS?

If this is the case,...

select from table1

where exists (select 1 from table1 where col1 = 'd') and exists (select 1 from...

Your first post mentions one table. Now you are mentioning many - how was I supposed to know this?

I made a mistake in trying to help you, because you did...

Nothing is displayed the way you have tried because you are saying:

'Give me all rows where col1 is d and col1 is i'

Col1 cannot simultaneously contain both values - hence...

ssurekha2000 (8/3/2013)

---

i have a table with 5 fields

field1 will have values as 'd' and 'i'

if the field1 of table has both the values then only the data shld e displayed

but...

JoNTSQLSrv (8/2/2013)

---

PATINDEX is just retrieving the index...

I see.

You can probably get quite close through the use of PATINDEX and diligent use of wildcards. Have you tried this?

If you can guarantee that the database is and will be in a...

Presumably you are using some sort of front-end application (Winform/Web) to get this info from the user. This validation should be done there and not by SQL Server.

Have a look at the 'Stairways' series for SSIS - this one[/url] may be relevant to your situation.

Ryan1 (7/31/2013)

---

Is there anyway to automatically map a flat file sources data types to the ole DB destinations data types? I'd rather not have to go through a data...

If your source is SQL Server, this is what I would do - use a query for your data source and include this...

I second Sean's comment.

The contents of the page linked to by Durai Samuel should not be relied on as they contain multiple incorrect statements relating to the nature and...

It's just the wrong forum. Try posting here[/url] instead.

I see! I agree with your comments...