<div>
please provide additional details ( more is better) and any related errors.<br />
for start:<br />
&quot;flat file it returns nothing.&quot; &nbsp;- you may need to check if your process is using UNC path to this file<br />
\\servername\share and appropriate permissions to access\write to this file
</div>


please provide additional details ( more is better) and any related errors.
for start:
"flat file it returns nothing."  - you may need to check if your process is using UNC path to this file
\\servername\share and appropriate permissions to access\write to this file

<div>
ralphp1355, if you want us to help you please provide the requested details.
</div>


ralphp1355, if you want us to help you please provide the requested details.

<div>
Because your experts could not solve it - I get more answers from stackoverflow.
</div>


Because your experts could not solve it - I get more answers from stackoverflow.

<div>
<div class="content wysiwyg-content">
I have a huge involved query - with lots of temp tables ect. At the end I do a Select * from temptable and it displays data.<br />
This query work in SSMS and when I paste it into a OLE Source - it returns the proper rows when I do a preview.<br />
But, when I place it pointing to a destination - database - flat file it returns nothing. Any thoughts?
</div>
</div>


I have a huge involved query - with lots of temp tables ect. At the end I do a Select * from temptable and it displays data.
This query work in SSMS and when I paste it into a OLE Source - it returns the proper rows when I do a preview.
But, when I place it pointing to a destination - database - flat file it returns nothing. Any thoughts?

ETL Sql Server OLE Source  displays preview data - but exports nothing

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.