Frank!

Thank you for a quick response.

What UDF's stand for?

Sorry I've never used SQL Server functions before.

Should I get rid of them or

change something to improve performance?

Thanks,

Robert

Jules,

No matter what TSQL we insert in source connection

Transformation can not be created.

Source in Transformation Tab is empty.

This is the main problem!

What do you mean by

"Try separating the selects into two separate transformations..."?

Put

SELECT RF_ID INTO #t1

FROM RF_INDEX

in transformation 1

and

SELECT * FROM #t1 INNER JOIN RF_INDEX

ON #t1.RF_ID =RF_INDEX.RF_ID

DROP TABLE #t1

in transformation...

... stuff your 12000 id's into a temp table on the source connection and do an inner join on that with transformations 2-10?  Then just drop the temp table when...

Ahaa!!!

So Global Variable in DTS can act as an array?

So in my transformations 2-10

how do I use Global Variable?

...WHERE RF_ID IN(select RF_ID from GlobalVariableName) ?

I'll go to "World's Biggest Book Store" on...

Can you direct me to some good description of this technique?

I've never used Global Variables.

You said:

Exec SQL task to capture the id you need and select it as an output...

Hi TnJMoseley,

I'm not sure I understand you.

What loop you are talking about?

My task is to transfer 10 tables but not the whole tables.

They are huge. I have some logic to...

Hi Steve,

Can you looak at

http://www3.sympatico.ca/3005/support/dts1.html

Is it what you mean?

I'm a little confused about workflow part.

Thanks,

Robert

Thank you guys for a quick response.

It was helpful.

But what if that .DTS file has connections

that don't exist on my computer.

Then obviously DTS package will fail?

Hi Peter,

Do you mean I can't access two different databases in one report? That's fine. I won't need it.

As far as I know, yes.

I will have to write (design) the reports myself.

There is an application Microwebs II running on web servers.

Then IIS Log Agent collects and does some...

Mike,

Thank you for your response.

This is going to be on the Web.

And I have Visual Studio.Net installed on my PC.

I also have SQL Server 2000 (server) on my machine.

How do...

Can a PK be not an Index at all?

Because I want to have a Clustered Index on

other than PK field?

So I don't need to create an Index on [User_ID] ?

By the way when you create an Index

in EM you have three options:

1) Create UNIQUE

2) Constraint

3) Index

"Creates As Clustered" checkbox.

And...

Ahaa!

Thank you very much.

Now I'm getting closer.

So is it a preferrrable method of

SQL Server users authentication?

Would you recommend to create

SQL Login for IUSR_MachineName account?

I'm just trying to think if...