<div>
I'm using flat file connection manager, Is there an option there to specify that. <br />
<br />
Textpad is fine opening it, but Business analysts cant read them as we do. So they need it in a readable format like spreadsheet for their calculations
</div>


I'm using flat file connection manager, Is there an option there to specify that.

Textpad is fine opening it, but Business analysts cant read them as we do. So they need it in a readable format like spreadsheet for their calculations

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
I've a 780 mb csv file which was generated via SSis &nbsp;stored locally on my system<br />
when i try opening it , &nbsp;it tries opening for a while and I get error &quot;file cannot be loaded completely&quot;<br />
it finally opens but cant find all the 1.3 million rows . Am I doing something wrong?<br />
Business wants to see in readable format.
</div>
</div>


Hi All,
I've a 780 mb csv file which was generated via SSis  stored locally on my system
when i try opening it ,  it tries opening for a while and I get error "file cannot be loaded completely"
it finally opens but cant find all the 1.3 million rows . Am I doing something wrong?
Business wants to see in readable format.

SSIS   CSV file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.