Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

SSIS Junkie

SSIS: Live Search Macro for SQL Server Integration Services

Just for a laugh I have started playing around with Live Search macros. In case you don't know, Live Search Macros are our way of building tailored search engines to search only specific content.

I went for an obvious subject for my first Live Search Macro - SQL Server Integration Services. This macro searches all of the following sites for SSIS content:

I deliberately haven't included Books Online in this list - if you want to search Books Online then go right ahead. This macro is intended to be for searching SSIS community content rather than the formal documentation. This list is by no means exhaustive nor immutable so if you have more websites that you think should be added to this list, let me know by posting a comment to this blog.

You can use the SSIS Live Search macro via this link: http://search.live.com/macros/jamiet/ssis/

You can even choose to search a macro rather than the whole of Live Search itself from right inside the address bar of IE7:

That's a great example of combining software and services into something that becomes wholly useful. 

-Jamie

 

UPDATE 10th April 2007 : This macro is now up on Windows Live Gallery too : http://gallery.live.com/liveItemDetail.aspx?li=0d838135-ead3-4f4f-b192-44c37f1d794a&l=4

UPDATE 1st May 2007 : It would be remiss not to point out that the same is possible with Google custom search. Robert Scoble talks about this here: http://scobleizer.com/2007/05/01/appleman-raves-about-googles-custom-search-capabilities/

 

Published 10 April 2007 03:42 by jamie.thomson

Comments

 

Alexander Gladchenko [SQL Server MVP] said:

;) http://msmvps.com/blogs/gladchenko/pages/685333.aspx

April 10, 2007 09:38
 

jamie.thomson said:

Excellent. Thanks Alexander, I'll update the list accordingly.

April 10, 2007 15:06
 

John Welch said:

Thanks for including me with all the other great resources in the list. I feel a bit outclassed :) , but I'm definitely honored.

April 12, 2007 02:32
 

Phil Brammer said:

http://www.ssistalk.com

April 12, 2007 15:16
 

jamie.thomson said:

Sorry Phil. I thought I had you on there :)

You are now!!

April 12, 2007 20:34
 

SSIS Junkie said:

Just a quick post. Many people on the SSIS forum have complained about the usefulness of the stock Transfer

April 19, 2007 06:04
 

SSQA - External Links said:

As you are aware SSIS is a newest technology within SQL 2005 version that has various enhanced features

April 21, 2007 20:48
 

John Welch said:

I was just using this to do some research for a forum post. Normally, I don't use this to look for my own blog posts, but I was looking for examples that were similar to a post I made last month. I noticed that my blog didn't seem come up in the results at all. Any idea whether this might be something in the search macro or something wrong on my site?

May 5, 2007 04:40
 

John Welch said:

In quickly testing this, the URL for my site shouldn't include a www prefix - it should be just agilebi.com/cs/blogs/jwelch.

May 5, 2007 05:18
 

jamie.thomson said:

John,

Copied and pasted from the macro:

site:http://agilebi.com/cs/blogs/jwelch/

So its strange that its not finding it. Do your posts show up on a regular search using http://search.live.com?

-Jamie

May 5, 2007 17:43
 

John Welch said:

Not sure if my previous comment made it in - if this is a repeat, my apologies.

Live Search does find my posts - try searching for "iterate resultset". After some more testing, it appears that it works fine if the site reference is "http://agilebi.com/cs/blogs/" but not if it is "http://agilebi.com/cs/blogs/jwelch/". I'm not sure why that is, but since my blog is the only one on the site (and will remain so for the foreseeable future), could you alter the URL in the macro to the shorter version?

Thanks,

John

May 6, 2007 01:51
 

SSIS Junkie said:

As regular readers will know I keep a keen eye on what is happening in our industry as to regards web

May 10, 2007 21:55
 

mitesh said:

how to create DTS

June 7, 2007 11:35
 

mitesh said:

i am in greate problem pls tell

June 7, 2007 11:35
 

mitesh said:

Any body pls help

June 7, 2007 11:37
 

mitesh said:

john u pls tell how to create

June 7, 2007 11:38
 

jamie.thomson said:

mitesh,

Please stop polluting my blog with your pointless comments.

June 7, 2007 16:34
 

Faris said:

Firstly great blog, lots of really useful info and tips.

Apologies if this isnt quite on topic, but spurred on by your example, I thought I'd have a quick look at Search Macro's and put together a TSQL Reference Search Macro:

http://search.live.com/macros/contraflo/tsql

Handy when you want to quickly check the syntax or some obscure options that can be used in a command.

Faris

June 8, 2007 16:34
 

SSIS Junkie said:

A few weeks ago I published information about a Live Search Macro that I had built to search for for

June 17, 2007 09:27
 

LuC said:

Maybe add?

http://groups.google.com/group/microsoft.public.sqlserver.datawarehouse/topics

and

http://groups.google.com/group/microsoft.public.sqlserver.dts/topics

June 29, 2007 11:59
 

free video codes for myspace said:

free video codes for myspace

September 18, 2007 06:56
New Comments to this post are disabled

This Blog

Syndication
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems