All,
I need to dump a table with more than 200 columns to a flat file. I tired in SSIS with the flat file destination, but it only allows 84 columns. What should I do if I want to dump all the columns to a text or cvs file.
Thanks in advance
Need dump 200 columns to a flat file
Hot Topic
- Getting the TXs on MIRROR
- How to reapply a trasaction log to a database?
- how to confine a field to be number characters only?
- Multi-valued parameter parsing for sp's?
- Wierd results with != operator
- looking for security guidelines to avoid sql injection risks with xquery
- Working around Temp tables in Reporting services.
- Dynamically Positioning the table in the report layout
- Stored proc concatenation problem
- Default Schema and Synonyms
SQL Server
- Sql manager
- Help with INSERT query
- Custom ControlFlow
- Select Error in Case
- Error Installing SQL Express (Error 1601)
- Problems running SQL Agent Jobs & SSIS Packages
- Problem in x64 SQL Server 2005 setup
- How to add 'ALL' as report parameter in drop down with other parameters
- ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot be used
- SSIS: Inserting unknown members from fact table
Need dump 200 columns to a flat file
Jupiter13
Yeah absolutely. Why not take the package constructed by the wizard and either:
1) Build your additional requirements into that package or
2) Copy and paste the objects from the wizard-created package into the package that you are trying to build.
-Jamie
Epete05
Try the Export Data Wizard in SSMS.
Right-click on the database-->Tasks-->Export Data...
-Jamie
Simplefi
Boozy
Hi, Jamie,
I have to make it as part of my SSIS packages. Is there a way to do it within SSIS
Thanks