Your request isn't really very clear ... I can think of several solutions, but can you elaborate a bit on the problem?

Don't set the connection string property. Set the ExcelFilePath property. I find that it causes fewer headaches than trying to build a string for the connectionstring, since unlike the other...

Yup, basically what christina said.

Use the lookup unless you're really running into memory restrictions. Lookup is *way* faster, and it's designed for this exact purpose. Just make sure that you...

SQL_Athmi (6/6/2011)

---

Difference Between the MERGE and MERGE JOIN

MERGE - similar to JOIN operation. Only joins only two inputs. If there are more than two inputs UNIONALL is used

MERGE JOIN -...

IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table which has the names of...

Honestly I don't really think you're giving enough information here for me to be able to answer that question.

What DateDiff in the case statement are you referring to? The one...

Yeah if you can find the example of the windows login that would be great. I assume I would have to log in to the machine that the database server...

I don't think there is a proxy account set up. I was looking into that, but I'm not sure which login I need to use in the proxy for this...

Hmm Jeff, now I'm getting the error:

The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.

Here's what I tried...

The last option, of course, if the cte isn't sufficient due to the size of the query or the need for indexes or something, is to create a real table,...

Why not just do this, as your source:

WITH cte AS

(

SELECT Comp.CompanyName, LEFT(Comp.CompanyNumber, 6) AS [Account Number], Quote.QuoteID,

MIN(Comp.PhoneNumber) AS Phone, MIN(CoTyp.AgencyTypeDescription) AS Affinity,

MIN(MktTer.MarketingTerritoryID) AS Territory, MIN(Co.CountyName) AS County,

CASE...

I'm guessing that, short of logging in as SA, there's no way of being able to get a database to be owned by SA?

Well unfortunately Lynn, that solution doesn't work - the user still needs access to xp_cmdshell, even if I use EXECUTE AS.

I've looked for other solutions, but it appears as though...

Create a blank template file, and a blank output file. As the first step in your process, use the File System Task, choose Copy File, choose Overwrite Destination, and select...

Seems like your problem is that the user which you are using on SSIS to connect to the database, doesn't have permissions to access the linked server.

But I think your...