Viewing 15 posts - 1 through 15 (of 31 total)
Peter Pirker (5/12/2011)
An error occurred while preparing the...
May 24, 2011 at 7:02 am
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...
March 8, 2011 at 12:51 pm
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...
March 8, 2011 at 12:14 pm
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...
March 8, 2011 at 10:55 am
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...
March 8, 2011 at 7:40 am
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...
May 28, 2010 at 11:30 am
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...
May 28, 2010 at 11:25 am
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...
May 18, 2010 at 1:05 pm
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...
December 15, 2009 at 7:07 am
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...
April 28, 2008 at 9:07 am
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...
April 14, 2008 at 11:56 am
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...
April 10, 2008 at 2:54 pm
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....
March 13, 2008 at 11:57 am
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...
March 13, 2008 at 11:32 am
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...
January 30, 2008 at 6:28 am