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.
| Author |
Topic |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2011-01-24 : 09:42:04
|
| Hello I need to pass a bulk of data contents of a CSV File to my stored procedure. Is there any way (apart from using Bulk Insert file option)to directly get the in memory data and drop it in the stored procedure for INSERT. ? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-24 : 09:45:08
|
| Use import/export wizard or bcpMadhivananFailing to plan is Planning to fail |
 |
|
|
srivatsahg
Yak Posting Veteran
71 Posts |
Posted - 2011-01-24 : 09:53:53
|
| But i need to do this programmatically...!!Is this possible or should i run the bcp command line utility programmatically ?? |
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2011-01-24 : 11:20:18
|
| If you are using .Net, there are a number of options here:http://www.sqlservercentral.com/articles/SQL+Server+2008/66554/ |
|
|
|
|
|
|
Alternative to Bulk Insert