I use sql Server 2005 to transport SQL file (table) to CSV using the "Flat fole destination" option.
I choose a file name with the extention of CSV

I use images which are better then words in this case. The wizard takes me through the proccess and does not live margin for error. then what is the error??. 

appreciate help

Thanks

Dov

The error tells you that you have not installed SSIS on the machine where the package is running - probably you've only installed SQL Server and Workstation Components. Another possible reason is that the package uses components that require higher edition of SQL Server - e.g. Fuzzy and Data Mining transforms require Enterprise or Developer edition. Please check this link.

http://blogs.msdn.com/b/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Hi,

There is a SSIS dev once wrote a document for the issue. http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx . It's detailed and should give you enough info to fix the issue.

Hi,

Try exporting your data with bcp tool (comes with SQL client) instead of SSIS wizard.

I upgraded to SQL server 2008 and added integration service.

the export works well but the column is not exlorted!

I mark  the "include Column names in the first data row"   but the column name is omited from the output

Dov

There are MANY ways to move data from SQL Server to a CSV file.

INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=D:\;HDR=YES;FMT=Delimited','SELECT * FROM [FileName.csv]')
SELECT Field1, Field2, Field3 FROM DatabaseName

Also, check out these links.

http://bpmdeveloper.com/sql-server-export-wizard-csv/

http://www.codeproject.com/Tips/1017732/SQL-Server-export-to-CSV

https://msdn.microsoft.com/en-us/library/ms175937.aspx?f=255&MSPPError=-2147217396

Hi Dov,

Please make sure you have already include check the 'Column names in the first data row' checkbox when choosing a Destination.We can use the Import and Export Wizard to export the data and check the issue again.

Thanks,
Katherine Xiong