Scalar Value Functions are new to me. I just googled them and it's clearly something I'm not going to fix today!

I've managed to get the query to run by...

Yep. Know what you mean. Been doing it on and off for a year and still very new really. If you think that's bad you wait till...

Cool. That's one I've not tried yet but sounds like a slick solution and one I could make use of fairly soon.

I've only just read both your...

Cheers Crispin - that's the prob

Thanks for all the tips. I'm not using any forms or anything. We provide the pass thru query and the people who run it will export to Excel...

Would really appreciate some help with this one.

Nope. I can't get the connection to work. Don't know enough about it and don't have time to look it up. Here's hoping someone can tell me...

Chris, I will try this and report back.

Trouble is that is a lot of code compared to what everyone else is able to achieve - 1 line is...

Thanks Chris - I've done all that. That's why I abandoned dates and started using numbers. I honestly can't pass anything from Access to SQL Server. If...

BillMitchell. I've been banging my head against this one all morning. I'm trying to pass a date, and my code looks exactly like yours. In the store...

Thanks for getting back to me.

I managed to get it working by putting my sql in a variable and setting SQLSourceType to Variable. When I first posted I was...

Myself and the previous poster thought you were using a data flow task. That would be easiest.

Add a data flow task to the contol page; set up...

hasysf (7/18/2008)

---

hello everyone

here is the scenario. I have a table in the oracle database and i am transfering its data to the sql server 2005. My destination table has all...

It seems to be a heavy subject and I'm still fairly new to the whole thing but, for what it's worth, I'm using xml files.

I've got one server and I'm...

On a similar theme, can anyone tell me how to write results held in variables to a different table?

I have a sql task that extracts a column of 3000 items,...