Hi Jack

No, not a linked server. Tables live directly in a database on the SQL Server.

Check out my comment. Looks like we posted about the same time.

I'm migrating to common...

Another comment from me:

I am just starting to use CTE's. I find they are easier to manage and perform better. This query started as a table joinded to a query...

wanted to post in case anyone was interested in outcome.

I went through the set up with the import/export wizard and saved it to a file and added the package to...

Good thought scott -- tyvm

I should have checked the topics first........i see i'm not the only one.

AHHHHHHHHHHHHHHHHH

I did not - so i just changed and got the same error message.

Let me recap exactly what i have - and oh by the way - much thanks for...

that is essentially what i have done.

i get an error message:

"the wrapper was unable to set the value of the variable specified in the executionvaluevariabel property."

thanks

let me provide a few more specifics.

First, i'm a beginner but fast learner.

The nine steps would be something like this:

Step1(Execute SQL Task)

SELECT some date

From some table

WHERE MyDate =...

thanks for the input.

I stuck in a where clause that significantly limits the data from a few million rows to a few thousand and it runs just fine.

As i mentioned...

thanks for the help.

can u tell which column within the query appears to be in need of an index??

hi

thanks for taking a look.

If you look at the query i am updating a table with results from a query not from another table. don't know if it is...

attached is the execution plan......i did not zip or change the file.....i simply changed the extension so i could upload it......change the extension back to .sqlplan

it is one to one.

i will try your suggestion however i'm curious why that would make a difference

bskt_skudtl has 650k rows. the specific week i am updating has approx. 17k rows.

The table i am retrieving from (trndtl_bts08) has 150mil rows.

i know how to display the...