steve

Cobol Has Change and it's become more web base then you will think. Check it out do some reserch with the Cobol Group site. if you need the Site name...

I have included several links that will give the information you need. if you need more help, you can drop me an e-mail.

first make sure you have the OLEDB/DDM

The OLEDB/DDM...

🙂

thanks for your Quick Reply.

the issue was solved I just need it to learn about eventdata()

😉

Instead of using the (8000) use the varchar(Max), another suggestion is to use T-SQL and let SQL do it, instead of front end Interfaces.;)

Thanks

I arrived to the same conclusion and did something similiar to the suggestion you made. and the Problem was solved.

thank y'all

😛

Thanks

all the suggestion you mention have been tried and still get a failure. the failure is refering to the actual Bulk Insert statement,

Bulk Insert @WholePath

from @path

with ......

thanks for the...

Put a little thinking into the process and then proceed to draw it on visio or something that will visualize it. then proceed to findout

what is available in SSIS. I...

make sure that you also have remote access enable on the sac console. 😎

😛

Q. are the Servers databases similar, if so why not link the servers

and go after the data? there are many ways to go after the data under this scenario, but...

Public Function ChangeQueryDef(strQuery As String, strSQL As String) As Boolean

' strSQL The SQL string for the querydef

If strQuery = "" Or strSQL = "" Then Exit...

friend, sorry it took me a long time. even to this is not the forum for Oracle, I will give you the answer. the linkserver works to get data from...

I believe you can as long as you are connecting using an ODBC.

there are several approches to this. make sure that the folder is a share folder and that the file does exist(no spelling horrors!).

second make you have the rights to...

is the oracle server linked to SQL?

can you tell me more about what the store procedure is looking like?