Peter Pirker (5/12/2011)

---

I got your example to work when I'm physically on the server, but when I try it from my workstation, I get:

An error occurred while preparing the...

Yes, this is while logged into SSMS under my own account. Actually, logged in as my sys account that we use here for servers, and which is sysadmin on...

Using the login's current security context, the error is:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)

Yes, I can open SSMS with "Run As" the account I...

I am using "Be made using the login's current security context" but it fails with all four, whichever one I use. I tried using "Be made using this security...

My concern is really with connecting TO this instance from another server (your #2). Yes, remote connections are enabled, TCP/IP.

When I add a domain account, which is...

Right after I posted the above, I found a suggestion on Microsoft Connect from 2008:

"There is currently no way to enumerate files in an FTP folder using SSIS. Even though...

I have the same problem. I need to put my FTP receive task inside a Foreach File loop, and I can't figure out how to specify the path on...

From the HR and employment law point of view, a formal, structured performance review process reduces company exposure to legal complaints by members of protected classes that they were singled...

Yes, it turns out there was a trigger, and the developer assured me that table had no trigger, and I could have sworn I checked for that, as I checked...

I agree that this situation can be very frustrating. I have always used the IMEX=1 solution and found it very useful.

Thanks for the script for importing from Excel, I...

Just to close the loop, in case anyone has a similar challenge:

I tried Execute As, and also Certificates and Signed Procedures, and neither of those approaches allowed the user to...

Further on this problem, I have the Access routine inserting a record into a table, which has an insert trigger on it. The trigger runs a stored procedure which...

Perfect!!! I had to put a Sort in both the flows and then used a Merge Join to get them back together.

I really do appreciate your help....

Thank you, Frank. I see how to configure the Aggregate component, I think, and that allows me to select the correct sequence nb. But I don't see...

Yes, at that link it does give the 4/8/08 date for the various editions, but for SQL 2000 SP4 it does not, it says until next service pack or the...