Did you or someone else go through the process of setting up a linked server? Remote Servers are being phased out in favor of Linked Servers.

Which server are you...

Okay, I found out that SSIS Lookups in Full Cache Mode are case-sensitive from these two places:

http://geekswithblogs.net/dtotzke/archive/2007/02/06/105585.aspx

http://sqlblogcasts.com/blogs/jorg/archive/2008/02/12/SSIS-_1320_-Lookup-Transformation-is-case-sensitive.aspx

I was able to solve my problem by going to the advanced tab and...

vaidyanathan_kalyanasundaram (3/4/2008)

---

Thanks steve for the reply..when is a service configured as LocalService and when is it done as Localsystem...

I understand that in case any sql service needs access to a...

Do you have a linked server set up?

Does d:\data exist on the SQL server? Always verify that the SQL server agent account has rights to the file location.

Thanks for posting the solution. So many times someone posts a question, solves it, and leaves us all hanging.

Clear as mud. All your processing is being done in the functions so without knowing what is happening in the functions there is no way to suggest optimizations.

The other...

That would have been my assumption, but it never hurts to ask.

Thanks,

Thanks for the explanation Matt. This is basically how I thought it would work, but trying to understand it sets my head spinning because it is so different from...

IMO, replication is going to be the easiest thing to setup. With replication you set up the publication(s) and subscribers and SQL Server does the rest. In any...

Yeah, no need for the clustered index, but a While loop is still RBAR and not really set-based. So you are using the table variable and the while to...

Jeff, Thanks for keeping me up too late again. As it seems I say often, I thought I was an expert then I came to SSC to find...

Guess I need to read BOL cover to cover. Never would have have even thought of a need for it. I'll take a look at the article.

Okay, Jeff, once again you have amazed me. I did not know you could set variables within an update statement and do the X= Y = Z syntax.

Now explain...

If you are an all SQL Server shop then with SQL 2005 you would want to look into using Service Broker which allows for Asynchronous transactions (not in the DB...