Thanks, this works in stored procedures or SQL.

What I would like to use is in the SSIS conditional split editor, to filter out their birthdate <20 years old.

The original oracle...

Thank you, it is very helpful.

Thank you, good to learn another option.

The only thing I am concerned is the records we have are about 400000.

I hear sort really affect performance, for this number of...

Thank you, in this case it is not actually a data warehouse ETL, it is just regular database daily upload.

But we need to load data in domain tables first,...

Elliott Whitlow (12/7/2011)

---

A little rusty on my expressions..

And this was a lot harder than I expected it to be..

Tried:

SUBSTRING(Genrder,1,1) == " " ? NULL(DT_STR,1,1252) : SUBSTRING(Gender,1,1)

It didn't like DT_STR, SO,...

Thank you, I will give it a try

Ninja's_RGR'us (12/6/2011)

---

The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other versions...

Sorry, I didn't make it clear.

In our enviroment is : install SQL database engine and integration service on one server, and then install SQL reporting service on another server along...

Thanks a lot!

Elliott Whitlow (12/5/2011)

---

Assuming you are using a Exec SQL task.

Command would be:

EXEC dbo.domProductCategory_LoadMerge ?

GO

On the Exec SQL Task, Parameter Mapping Tab, click add

For Variable Name Select: System::PackageName

Direction: Input

Data Type: varchar

Paramter...

Thanks, I have added the parameter to stored procedure, but I cannot make the ssis part correct, can you tell me a little in detail how I can make this...

I just did it, by rename it, then click reload with upgrade.

Thanks!

So do you mean you cannot reproduce this too?

I tried rename it, hit yes, rename again, hit yes, rename it... yes,

still the scope keeps the same.

Thanks, not sure why my original ones work too. the one not using boolen, and with '' around True, false.

It must do some implicit conversions behind.

But I changed according to...

[No - switching the recovery models does not reduce the amount of logging on deletes. The amount of data logged will be exactly the same whether in simple, bulk_logged...