Good Article with useful info. Thanks

rlondon (11/9/2009)

---

Thanks for the information. I will look into that as another option, but still looking for something that I can just open up and vew all of my...

Visioconference

the script repository here at SSC also has some scripts that would be of use. Check those out too. Download a few and find the one you like...

We need more information to help. Some great comments have been...

I think a script component task would be your best bet. We use the scripts for similar functionality.

nice analogy Alvin.

It sounds feasible and doable.

Do I understand this correctly?

1. In SSIS, but only using SQL tasks and .Net Script components?

2. Reliable FTP?

3. FTP needs to be secure?

12 Tables in a join is a handful. However, I have seen it done many times over at several clients. A little query tuning can go a long...

Keep in mind, that is only checking for the first column in a foreign key. You will need to add additional code if there is more than one column...

This might get you close to what you want.

select o.name,c.name from sys.sysreferences r

inner join sys.syscolumns c

on r.fkeyid = c.id

and r.fkey1 = c.colid

Inner Join sys.sysobjects o

on c.id = o.id

Left Outer Join...

When the query isn't running, what is your processor usage?

Doh, option 6 tripped me up - should have read it more closely.

Amazing how sideways the Thread goes when talking about Pork Chops and Kilts.

Now there's an image - Kilts with Pork Chops.