Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Reading from a data file

Author  Topic 

DrewBurlingame
Starting Member

49 Posts

Posted - 2001-07-11 : 21:25:07
Hey all,

We've picked up a client who is using EDI. I need to set them up immediately, so I need read from their data file into procedure variables. What is the best way to do this. I looked at Bulk Insert and BCP, but they both read directly into tables and that won't work for this scenerio. There are too many "if's" Is it possible to have a stored procedure read a data file into variables?

Thanks in advance for your help.
Drew

   

- Advertisement -