CODEWITHSUNDEEP
sqlsql-serverssissql-server-2012msbi
bmsqldev
bmsqldev

Reputation: 2735

Dynamically Created Excel From a Excel Template not writing Data Properly -SSIS

I need to create a SSIS Package which will run daily and export a table's data into a directory. The Exported excel have a predefined format. So I have used a template excel. (Excel File with Column Headers only)

Here are the steps I followed:

  1. Created a variable Filename with holds the location and name of the excel to be generated (based on current date value)

  2. Added a File System Task in Control flow. Give Source as Template Excel and Destination as the Filename variable.

  3. Added a Dataflow Task in control flow and connect it with File System Task.

  4. In Dataflow Task, added a OLE-DB source and configure it with the source table (the table data needs to be copied into the excel )

  5. Added a Excel Connection manager and changed Excel File path property to filename variable.

  6. Added a Excel Destination and configure it with Excel Connection manager.

  7. set Delayed validation true in Data flow task and Executed the package.

Control Flow:

enter image description here

Data Flow:

enter image description here

The Package is running successfully and the excel file also get generated in the desired directory. But the excel file skips around 19000 rows copying data after that . why it is happening?

Can any one help me to solve the issue.

Thanks for the help

Upvotes: 0

Views: 1517

Answers (1)

ɐlǝx
ɐlǝx

Reputation: 1394

It is possible that the file is already formatted , and that lines are down at the bottom...often excel jumps or add lines if you do not delete the lines already used even if empty...we must also consider strange events!

Upvotes: 1

Related Questions