In the first query, the use of ISNULL on the columns you're applying the filters to is forcing a table/Clustered index scan as the engine cannot use any covering indexed...

It's not in 2005, but I *believe* this is available in 2008

HTH

Andrew

Not trying to be...

There's the System::MachineName variable - I always tend to use this in environments where the environment is less "controlled" and the package may be moved at short notice.

Well - actually...

Pac123 (11/8/2010)

---

PaulB-TheOneAndOnly (11/5/2010)

---

Here is the...

Jeff Moden (11/2/2010)

---

andrew gothard (10/30/2010)

---

As a side bar, I never load data directly into the "final" table from an outside source (like a file). It's too risky for a...

As a side bar, I never load data directly into the "final" table from an outside source (like a file). It's too risky for a multitude of reasons. ...

Build the command in a string and use EXECSql to run it

DECLARE @sql VARCHAR(1000)

SET @sql = 'CREATE TABLE ' + '[' + @otherdb' + '].[dbo].[my_new_table]'

Exec ( @sql)

Have you tried starting Task manager on the server and seeing if there's a process eating memory?

rocky_498 (10/29/2010)

---

First of all i really appreciate your reply. I am using SSIS to finish this project, and i am using EXCEL SOURCE file and OLE DB source. i...

Be my guest. Not entirely sure how you intend that to be of use in an interview, but...

Craig Farrell (10/29/2010)

---

andrew gothard (10/29/2010)

---

Ah - in that case - what I've done in the past is to have the script object parse the filename - set a value in...

Not sure what you're getting at mate - do you mean that you want the process to add a datestamp as the records are entered, if so from when te...

Ah - in that case - what I've done in the past is to have the script object parse the filename - set a value in a variable and then...

Personally I'd *probably* use a staging table for that, rather than do it in SSIS, particularly if you can set up an SP in the source which is appropriately indexed...