Mark Forums Read

Searching for text in package

Go Back

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reply

#1

Old

c-eric.geil@mci.com

Posts: n/a

Searching for text in package - 04-22-2008 , 09:03 AM

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#2

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#3

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#4

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#5

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#6

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#7

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#8

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

#9

Old

nite_eagle@hotmail.com

Posts: n/a

Re: Searching for text in package - 04-24-2008 , 03:40 PM

A 3rd party utility like DTS Package Search will do the trick.

http://www.dtspackagesearch.com/

On Apr 22, 9:03 am, c-eric.g... (AT) mci (DOT) com wrote:

Quote:

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to
track down any place the old one was listed.

Is there any way to do something similar for the tasks within DTS
packages in SQL 2000?

Here's what I'm using for jobs, I'm basically trying to find the same
info for package tasks:

SELECT sysjobs.job_id, sysjobs.originating_server, sysjobs.name,
sysjobsteps.step_id, sysjobsteps.command, sysjobs.enabled
FROM sysjobsteps INNER JOIN
sysjobs ON sysjobsteps.job_id = sysjobs.job_id
WHERE (sysjobsteps.command LIKE N'%olddomain.com%')

Thanks

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.