Export Data to Flat File using SSIS Package

0
votes

I am trying to export a database table into delimited flat file using a SSIS package. My database table has about 31 rows and it looks like below - enter image description here

When I am editing the Flat file connection manager, the preview doesn't show any rows. What is the issue? Snapshot is below -

enter image description here

1
sql-server-2008ssis
you can only preview data in input source not in output, output will only show definition and mapings – paranjai

1 Answers

1
votes

That is a preview of the output file. It will only show data if the file has been created and has data in it.