thanks. I have added a group to a user role, but I have a feeling my server is not "visible" on the network. I know this is bleeding...

Through a shared data source (for reporting services) or an .ODC file to connect an Excel doument.

thank you all. both marked as sol'n

Cheers!

Thanks. It now shows up in select * from sys.servers

However select @@ServerName still returns null (curious)

I can use this workaround if needed :

select * from sys.servers where is_linked=0

richard.bowles (9/18/2014)

---

You...

I get a list of about 9 servers

Server_ID, Name, Product, Provider.

But NOT the name of the Dev server that I run the : select * from sys.servers from

richard.bowles...

Now we're onto something.

On my local instance (2012) :

SELECT @@SERVERNAME

returns the name of my local server

On the DEV team's server (2008R2) :

SELECT @@SERVERNAME

returns NULL

richard.bowles (9/18/2014)

---

What does

select...

Thanks for the response. Still "NULL"

Ok. Is there anyway to simply package the PowerPivot document with the PPT presentation (cut the need for a SP connection out of the loop?)

I wanted to use an event handler but it seems that the Redirection doesn't raise any events

Also I don't want to hear about something better down the road. Is it common in a large

ETL to have an error output from every component in the DF?

I am looking for a slick alternative to minimize clutter in the package.

I guess my question boils down to this :

Is there a way to continue processing rows after encountering the first

error in a dataflow task without using row re-direction?

thanks

that's correct.

the OnError event handler is a stored proc which inserts rows into a row-level error table.

it also inserts system variables (package name, user name) into a container specific table.

the...

yeah I am trying get away from row redirection.

basically I want to leave the rows that have errors in the source table,

and just flag them with 'Error' in some flag...

Ok thanks

What I am trying to do is use flagging instead of row redirection.

For example :

Source data has 10 rows

There is an error in row 3 (say violates null constraint...