Exporting A DTS to Excel as snapshot

[Mohammad Abdullah]

Hi,
If I have a (DTS) sql server 2000 package that bring a dataset , I want to import this (DTS) package to Excel file , the Excel file take it is design from another template file , can you provide me by an example about this operation.

Note: Provide your example by (C# . Net).

Thanks

[Mohammad Abdullah]

I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

[Administrator]

Hi Muhammad

Why do you don''t perform the export directly in the DTS, because you have there the possibility to export the data to Excel.

Regards
Thomas

>I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

[Administrator]

Hi Muhammad,

We have an ImportDataTable method that would do that, but it would internally loop thro the 10000 rows.

IWorksheet.ImportDataTable()

//The imported datatable data will start from [1,1] in the spreadsheet.
mySheet.ImportDataTable(GetTable(),true,1,1);

Thanks,

Stephen.

>Hi Muhammad
>
>Why do you don''t perform the export directly in the DTS, because you have there the possibility to export the data to Excel.
>
>Regards
>Thomas
>
>>I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

[Mohammad Abdullah]

Thank you so much stephen , no one gives me this good answer before , I asked this question around 10 times before no body gives me a good and enough answer like you.

Thanks again