Running CLR through a OLE DB Command

hi does any one know how to run a CLR proc through ole db command. it works fine if it's a t-sql, but i need to feed data to a clr through parameters which i'm getting from a OLE DB source

following error comes up

error at data flow task [OLE DB command [169]]: an OLE DB error has occurred. error code: 0x800004005, an OLE DB record is available....
"syntax error, permission violation or other nonspecific error.

with t-sql it will show the column parms where you can map.

i tried creating a t-sql that takes in parm and calls the CLR within tsql it works fine. but it really looks silly (tsql that calls a CLR with it's exact parms). thats i thought there has to be a way from ole DB command where you can directly call a CLR proc

any ideas




Answer this question

Running CLR through a OLE DB Command

  • Running CLR through a OLE DB Command