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.

ChrisM@Work (8/22/2012)

---

Cadavre (8/22/2012)

---

Phil Parkin (8/22/2012)

---

Maybe I jumped to the wrong conclusion - I didn't spend much time considering the question itself. I just liked the fact that you had used...

Lowell (8/19/2011)

---

here's a snippet based on Seans example, that gets all the tables in FK hierarchy order and generates the Truncates/delete commands for you, so you don't have to drop...