Jeff is spot on. You don't get SSIS with SQL Server Express.

-Jamie

Your OLE DB Source component can take its SQL statement from a variable (AccessMode="SQL From a variable").

-Jamie

Janette,

No, you shouldn't need to do that.

I'm struggling to see why this wouldn't work. Are the datatypes on the variables identical?

-Jamie

Janette,

How are you attempting to "pass this variable to child packages that are being executed from within this parent package"? Are you using a parent package configuration?

-Jamie

Jeff,

I assume you're aware of the methods here? http://www.sqlis.com/default.aspx?311

This would be handy functionality to be provided in the import/export wizard though (if it isn't there already).

-Jamie

Easy guys, it was only a typo (not mine by the way). I'm sure we've all been guilty of that in our time!

Apologies for the delay in replying, I have...

In case anyone replies...

OK, overloaded use of the word "Dts" I think

There is an object available to you in a script task called "Dts" that enables...

I actually prefer the script component method which makes the variable visible in the Intellisense dropdown.

-Jamie

Hi Miles,

I've just checked in the September CTP and I'm afraid if Marcin is saying that you can use the "DTS." syntax in the script component then she/he is incorrect....

I dare say there is. My guess is that its something to do with the inherent differences between the base classes for tasks and components.

I can't offer much more than...

The Dts notation is used in script tasks. The question clearly states "I have a script component that ..."

I refer you again to the link I posted in reply to Chris'...

Yes there is.

Check BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/d189e84c-140d-4466-96da-7d21a704316d.htm

In "Differences between the Script Component and the Script Task"-->"Using variables" section.

Regards

Jamie

Just in case anyone replies!!!

Thanks Carl. I'm using CONNECT BY and its working a treat. I'm quite impressed actually. Same functionality as a CTE yet alot less wordy.

And before anyone castigates me...yes I know...