I created a SSIS package to export DB to a text file but somehow there was a lot of error after the package created. I cannot attach the file with error message

Will need the errors. You can use say SkyDrive to upload the errors file and publish a link here.Arthur My Blog

package validation error......... Where to find step by step to export DB to a text file with SSIS package ?

I uploaded the doc with screenshot error. How can you find it?

package validation error......... Where to find step by step to export DB to a text file with SSIS package ? and I uploaded the doc with screenshot error. How can you find it? You cannot export the whole database to a single file. Typically each database table gets exported to a separate comma delimited file. I suggest using my favorite Data Export Import Wizard: http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm A bonus using it is that you can save the export routine as a SSIS package that you can later open in BIDS to modify or even learn how it generated it. To give us access to the errors file you need to share it. This link shows how to: http://www.ehow.com/how_2314965_use-windows-skydrive-share-large.htmlArthur My Blog