I have a further question, is this connection string likely to be the same one that the rest of the package is using?

CEWII

It can but I propose a different solution..

Using DNS create a name for the server and point it at the Prod server. You will need to be using a...

What have you written? A custom control flow task or a DLL that is referenced by a Script task?

You could create a variable at the package level and use...

I just wanted you to understand that even with a between operation you need to keep in mind time..

Start Date: 8/26/2009 00:00:00.000

End Date: 8/27/2009 00:00:00.000

Values: 8/26/2009 01:00:00.000 <-- Will be...

Just off the top of my head..

1. You could add each column as nullable

2. Populate the columns in reasonable batches

3. Alter each column one-by-one to NOT NULL

Rationale behind these steps

1....

Access wants you to go through its engine, even when you do pass-thru queries you are going through its engine. You lose a lot of control in the process....

I think I have your answer:

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/

Use a SQL Select Statement to Retrieve Data From a View

Avoid using the Table or view access mode in the OLE DB Source Adapter. It...

George, That was my thought as well.

CEWII

What I can go onto saying is pretty much anything BUT Access..

CEWII

I can't remember for sure, I know there is a reason, but I can't remember why. Sorry man..

CEWII

I'm wondering if George might be onto something.. Does MS still sell 2005 or do they sell 208 with downgrade? I completely agree with everyone here, you need...

Do none of these people know how to google a problem before they post? I've had a couple that their resolution was already posted in another thread HERE on...

SQL 2008 BOL (April 2009)

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/d1a82fbe-c178-42bb-9212-fbdc520a8f8d.htm

I think this is what you are asking about..

CEWII

ASP.net, Winforms (VB/C#/etc)..

CEWII

I'm thinking the problem is parsename is probably tagged as non-deterministic.. Not sure why, if you feed the same value in you should always get the same results..

I think...