ganeshkumar005 (8/24/2012)

---

for 'D1234', the first time it appears while reading from top, the value against it is 1001. I want this row in result. And skip the others if 'D1234'...

ganeshkumar005 (8/24/2012)

---

I have a table:

D12341001

A11224001

D12342001

C13425001

B19646001

A11223001

you can see leftside values D1234 and A1122 are repeated. Now I want the result as very first numerical ID returned when I meet the alphanumeric...

Charmer (8/24/2012)

---

i read the article Phil,

Could you please give me your idea for my condition?

My situation is , Look up or...

Consider changing the cache mode. See here.

raghuldrag (8/23/2012)

---

select slno,goals_type,entrydate,

goals,date_of_commitment,kpi,

weightage,goals_review_date

--into #temp

from LIMS..GOALSDTL_Audit where accyear>='20110101' and accyear<='20120101'

and empcode=002244 order by slno

how to create procedure for dis..... while i am crearting procedure its...

Koen Verbeeck (8/23/2012)

---

The easiest solution would be executing the stored procedure in the OLE DB Source, but not storing the results in a temp table but sending them to the...

I've used the File Watcher task in the past for situations like this. See here.

In summary, you execute your package with the FW task as the first task in the...

MSzI (8/23/2012)

---

I would suggest:

IF EXISTS (SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[ABC_SCHEMA].[ABC_TABLE]') AND [Type] IN (N'U'))

DROP TABLE [ABC_SCHEMA].[ABC_TABLE]

Because:

1. It's safer to check the schema in witch the...

What language is this that you are coding in?

Actually, my name is now 'Pro' 🙂

n79799 (8/22/2012)

---

If you really want to directly check for a config file's availability, you can have a script task at the beginning of you package, which checks for the file...

You appear to have written your entire question in the subject line, leaving the body of the question blank - but you are new, so please be aware in...

Karan_W (8/22/2012)

---

I have Sql server 2005 business intelligence development studio installed into my machine.I need to develop one SSIS package.

requirement is:

1: read the raw text or CSV file which doesn't...

Sorry, my first post was rubbish. Try this:

create table #temp...

--edit. Removed post.