Hi Steve

Thanks for your reply.
Unfortunately, there are no triggers on the tables.

I was thinking that as SQL Server has configuration script that allows distributed queries,...

Great Kevin.

Thanks. I will try this.

Cheers

William

Thanks Thom

I was hoping there could be a preprocessor method that would remove certain character before SQL engine started processing the string.

But I understand that the Parameter object would do...

Hi Chiara.

Thanks for your reply

In the end I did the same as the first example. I took my class vrom VB6 and compiled it into a dll. I just would...

Thank you very much. I see a light shining at the end of the tunnel

Cheers

Ok, I see you can do this through Enterprie Manager.

But, on a huge production server, Would this not be a huge impact ?

The SQL Server we are using is hosting...

Hi Jaredsimi

Thank you for your reply.

Please explain Change the service to run as a user with network access for me.

How do I get the service to run as a user...

As far as I know, DTS inserts data only (when you talk about the transformation tasks)

But DTS also contains the SQL Query object in which you can execute SQL Queries...

Your files need to look like a reasonable input file. You cannot have more than one type of delimiter, and the fields should be in 1 row to be called...

Hi Guys. Thanks for everybody's inputs.

So far, there is no answer yet for me.

As for creating each step as a DTS and executeing each from another scheduler ...

Doesnt that...

When you click on the Lookups tab in the transformation form, you can add a lookupname to the list of lookups. Select the datasource for this lookup and then click...

To the Site Owners.

I must admit that my question is a shot in the dark, as I have search the web (and MS Sites) in order to find an answer...

I dont know Oracle field types : Is the LONG field type equivalent to a VARCHAR in SQL ?

Thanks for your answer David (and comment).

I suppose when one is working with DTS and because of the DTS this problem arises - One could classify it as probable an...

So what you are saying is that I must log on using the Domain/Username and password of that account I login with for the Terminal Services session ?