• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

load bulk data to excel using vb.net

Hi

I am using VS2005 with asp.net and vb.net for back end code. I need to export huge datasets of upto 3000 lines from SQL2005 to Excel2003 to create reports. I have a method that is working now but because its writing the data set to excel row-by-row it takes quite a bit of time. Is there a way i can load it faster instead of going row-by-row?
0
ewesley
Asked:
ewesley
  • 4
  • 2
1 Solution
 
RejojohnyCommented:
0
 
ewesleyAuthor Commented:
Thanks Rejo,

I have looked through this stuff and have been able to test an SSIS project when loading data from excel to sql2005 successfully,

However when moving the data from sql2005 to excel i have a couple of problems, (forgive me if they are dumb as i am new to this)

1. What exactly is supposed to be set as the string value in the RemoteFileUrl Variable?
2. If this works successfully, how would i link it to my asp.net web project from the intergration services project?
0
 
RejojohnyCommented:
Glad that you got that working .. what you might have noticed is the speed at which your export works now ..
1. I am not sure about what exactly you mean here
2. You can trigger SSIS objects from ASP.net .. i am sure you will find samples in the SQLis.com site that I have given above .. do let me know if you are able to get to any samples and I will try and find them for you ..

Rejo
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ewesleyAuthor Commented:
Rejo,

WHile the SSIS stuff is very intresting i have not been able to find a way to use it in my solution.

I am using dynamic SQL and my select statements have both the columns and tablenames as parameters.

select [column names as arraylist]
from @schema.@tablename

Is there a way to use SSIS in this manner?

I have also not see how i can use the SSIS project from my vs2005 application though i have not done much research on this as yet.
0
 
RejojohnyCommented:
yes, there is .. within SSIS, you can call a stored procedure which builds the dynamic SQL or you can even call a script within which you can create the SQL and execute ..

Rejo
0
 
UrbizagasteguiCommented:
It could be done in SQL Server 2000...???
0
 
RejojohnyCommented:
Urbizagastegui, yes this can be done in SQL 2000 too .. its called DTS .. try sqldts.com for more info ..

Rejo
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now