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 |
|
deeputom
Starting Member
2 Posts |
 Posted - 2009-08-19 : 04:31:42
|
| Hi allI am inserting files into SQL server using bulk insertion.Can anybody tell me how to do it using variables.I will store the data in a structure and how to insert this structure to the SQL server.Inserting using files is taking time.Please help.RegardsDeepu |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-19 : 05:25:22
|
| What do you mean by "using variables"?In SSIS? SqlBulkCopy class (.Net)?BCP/BULK INSERT can be really quick in loading data. Please explain how you're loading the data. |
 |
|
|
deeputom
Starting Member
2 Posts |
Posted - 2009-08-19 : 06:19:40
|
| We are storing data in files.Using bulk insert we are storing the files data into SQL server database.The process of storing data into files and pushing the files to database is taking time.Instead of this process, if we store into variables(eg structures) and pushing the data stored in he variables to the database we think it will reduce the time.Is there is any method to push bulk records stored in variables to the database. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-19 : 10:26:08
|
| why not have the app that writes the files just write to the database? |
|
|
|
|
|
|
Bulk insertion into SQL Server 2005 using variable