Got to ask, what is the fiscal year? Also, what do you consider a fiscal month?

Any differences in execution plans between dev and prod?

I've been working with SQL Server for about 12 years now. I use BOL regularly. I also have a portable library in my car with about 8 SQL...

In your data flow, yes, add a lookup. If successful, do an update. If it fails, do an insert.

Just like you would have to if creating a permanent table. Base the column types off the data you are going to load from your queries.

To be safe, I'd disable the job while deploying a fully tested update to the SSIS package.

At the start of your stored procedure, create your temporary table. Then use INSERT to put the records into the temp table. Do your additional processing.

I'd set the autogrowth to a fixed amount, not a percentage.

debbie.coates (10/29/2008)

---

(This isn't my actual select query, its just an example, but i still get the same error aobut there alread being a #temp. Is it something to do...

How about posting the actual queries you are running?

Davroche (10/29/2008)

---

We need the DDL for the table(s), create statements. The tables are already there I did not create them. I am simply querying the data. I...

Read the article identified below, then post the DDL for the table, some sample data, and the expected results based on the sample data. This will help us help...

That would work also.

Use your DDL trigger to dynamically build and start a job that performs the backup operation. The job should also delete itself upon successful completion so that you don't...

Easy fix:

select

a.cuslink,

a.sequence,

a.effdate,

a.site,

a.entercd

from

#list1 a

...