Thanks Phillcart.

Robert

Thank you so much phillcart!

That's a very good finding.

Robert

Hi Mike,

Thank you for your response.

If I save my DTS as .BAS file I can locate that ghost Task

and remove it from code but then how do I convetr it...

WHERE (METHOD = 'STANDARD' AND EFFECTIVE <= ? AND EXPIRY >= ?)

Won't it be looking for the second Input Parameter?

I thought it retrieves parameters one by one.

So it would look...

I don't know.

It just works. I have SQL Server 2000 Server component installed on my machine.

It's SP3. Maybe it makes a difference?

I saved the package, closed DTS, opened it again and now it works.

Hi Phill,

You're right. My problem was that I was thinking

DTS will not work if I manually change ObjectNames.

Phill, can I ask another question?

I have this code in my SQL task:

--------------------------------

DECLARE

@INTERVAL_ID smallint,

@mbvarCOBDate smalldatetime

SELECT...

Setting connections dynamically in INI file

does not work smoothly in my case.

I have 10 Transformations and even if I change the value of DestinationDatabase in INI file from "MBVaR" to "MBVaR_NEW"

and...

I did try Red-Gate.

I couldn't save the results in CSV or any other format.

After I played with it for an hour I gave up.

You were absolutely right - parenthesis.

It all works great now!

Than you so much, NOELD!

Hi noeld,

Thanks for a good idea.

I created a function.

But something is wrong in this part...

...CHECK

(

dbo.udf_RatingExists(Rating = 1)...

It gives me an error

Tree is fine.

Do you know which tool it is?

A lot of things in the existing procedures look ugly to me.

The problem is I don't have a mandate to spend time on optimization of the existing code.

I just...

Frank,

I just read a couple of articles

in BOL and the article

"SQL User-Defined Functions" has an example

with CREATE FUNCTION LargeOrderShippers ( @FreightParm money )...

This is the exact method that is...

So , Frank

The idea is (if I understood your example correctly)

to avoid calling other objects from UDF (sp,views)

and instead to retrieve all data

inside the UDF.

Am I right?