Thank you for the insight. As always this site is very informative thanks to everyone that contributes.

GilaMonster you make a good point as well.

GilaMonster,

No testing has been done yet as I'm in a "merged" logical and physical design phase.

I'm probably hesitant of using the lookup table with a FK relationship because of the...

GilaMonster,

Thank you for the reply as well.

The actual table utilizes a PK/FK relationship for other tables associated based on the "EmployeeID" (really ShipmentId or InvoiceID) with cascade delete/update. I know...

L' Eomot Inversé,

Thank you for the reply.

This was a generic example but a few actual examples would be statuses applied to invoices and shipments, both of which will have...

GSquared,

Thanks for the reply. That's a bummer to hear. I'd figure the auto-mapping feature would be something available some how. The columns will be named the same as the original...

Gary,

Do you have to use Active X?

I've written packages where I'll list all the files in a particular directory and then process them one at a time. I do...

Sean,

Thanks for the reply. Appreciate it.

I did setup a task but the least amount of time is a file that is older than an hour. So I created a file but didn't feel like waiting...

I know SQL integrates with many of the .net languages so I wonder if something like this would work....

http://msdn.microsoft.com/en-us/library/ms190790.aspx

I have no experience with this so I'm not sure...

Thanks Elliot for your feedback. It is a dll so it's in process. There are many methods that this dll supports... VB,C#, Access, API calls etc... I'm just trying to...

It seems you can execute configure SSIS jobs to run in 32 bit runtime environment however I'm not running a job. I'm executing this directly from a proc.

Would it...

Thank you for the encouraging words... lol!

I was kinda expecting that answer. I've been researching it and it seems to be the overall opinion for most scenarios.

I can't tell...

I have SA privileges on both servers. If I setup a login using my domain username and choose impersonate the query I run thru EM fails.

Msg 18456, Level 14, State...

Thank you everyone for the responses.

Bob I used your method (both servers are on the same domain) and it worked.

Quick question: When I browse the tree view in...