Export Data from SQL Server 2005

hello,
In our .NET application, we have an interface where users can type/execite
any query/stored porcedure and export the results to a flat or Excel file.
We were using DTS objects to do this. Now that DTS is dead and we need to
use SSIS, can someone point me an article which basically explain how to
export data from a SQL Server table/view/query/sp to a flat file using SSIS
within a .NET application?.
Please note that large volumes of data will be exported so performance is a
big concern.. Otherwise I would have loaded the results to a dataset and
could have written it to a file in any way I want.
Thanks for your help,
Ganesh
Hi
You may want to start at
http://msdn2.microsoft.com/en-us/library/aa337077.aspx , the library names
are confusing in that they are still called dts e.g.
Microsoft.SqlServer.Dts.Runtime
John
"Ganesh Muthuvelu" wrote:

> hello,
> In our .NET application, we have an interface where users can type/execite
> any query/stored porcedure and export the results to a flat or Excel file.
> We were using DTS objects to do this. Now that DTS is dead and we need to
> use SSIS, can someone point me an article which basically explain how to
> export data from a SQL Server table/view/query/sp to a flat file using SSIS
> within a .NET application?.
> Please note that large volumes of data will be exported so performance is a
> big concern.. Otherwise I would have loaded the results to a dataset and
> could have written it to a file in any way I want.
> Thanks for your help,
> Ganesh
|||To add on to John's response, there's an SSIS CreatePackage sample project
that creates a flat file from an OleDb data source. You might use that as a
template to get started quickly. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ganesh Muthuvelu" <GaneshMuthuvelu@.discussions.microsoft.com> wrote in
message news:E0115B43-545D-43D0-9B0F-61C3D7AF7CE0@.microsoft.com...
> hello,
> In our .NET application, we have an interface where users can type/execite
> any query/stored porcedure and export the results to a flat or Excel file.
> We were using DTS objects to do this. Now that DTS is dead and we need to
> use SSIS, can someone point me an article which basically explain how to
> export data from a SQL Server table/view/query/sp to a flat file using
> SSIS
> within a .NET application?.
> Please note that large volumes of data will be exported so performance is
> a
> big concern.. Otherwise I would have loaded the results to a dataset and
> could have written it to a file in any way I want.
> Thanks for your help,
> Ganesh
sql