I was looking at microsofts code.. and running EXEC master..xp_logininfo @acctname = NULL,@option = NULL

One thing I see is that permission path is NULL, shouldn't that have my domain group...

The domain group is set up as a login.. but when I run.. I get the following error:

Msg 15404, Level 16, State 5, Procedure xp_logininfo, Line 42

Could not obtain information...

Thanks will do.

Hey thanks for the help.

Keith Tate (5/8/2014)

---

ASYNC_NETWORK_IO usually doesn't mean that you are waiting on the network. It usually means that the application is processing the data one row at a time or simply...

Hey Andy.. When you are working on the OLE DB Destination, why would I get the error "No column information was returned"?

I have the update statement, just like the one...

I even created a new package.. with just one control in the "Control Flow", and that was the data flow task. I just put the New BOR Records (OLE DB...

Eirikur Eiriksson (4/16/2014)

---

dwilliscp (4/16/2014)

---

I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.

But looking...

It is set at 20 sec.. I would think that should be long enough...it is a SQL Auth login, so all the server has to do is process the request.

Deleting is not a problem we have... but I would like to know who is creating server links between servers that should not get created. I am currently unable to...

Thanks... I dropped the RIGHT and used substring, and this seems to work

substring(col1,charindex('-',col1)+ 1,len(col1)) as col1,

Hard coding where the '-' does not work since it varies, so the below does not split correctly

--RIGHT(col1,(LEN(col1)-6)) as col1,

I tried to fix it by using the below but...

Ok, thanks for the help.

Jeff Moden (12/31/2013)

---

What privs do you have on SQL Server itself? Do you have "SA" privs? If not, you're pretty much stuck. If you do, then it...

JohnFTamburo (12/31/2013)

---

dwilliscp (12/31/2013)

---

Is there anyway to stop and start the agent, if you are not a local/network admin? As a DBA IT will not give me local or network admin...