I broke down and wrote it as a Cursor... Still running so I do not know if my code is correct yet... I will create a table and some dummy...

dwilliscp (7/25/2014)

---

I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource"...

I am working with our AD team to see what is going on... while the MSDN site does not say any thing, I think it is permission related. There was...

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...