SSIS execute sql task to write in excel file

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  July 27, 2019 at 1:16 pm

  #3666545

  hi ,

  i need to load data into excel file from SQL table , but in excel file some of the fields should come as a numeric and not as a text.

  for that i created a template with the appropriate data type, i am loading by copying template and after the first row(first row is a dummy data into file) and then i m removing data from the first row, which give me a blank line in excel.

  now i am overwriting that blank line with values and which is working fine, the only problem is [DATE], i have some columns in table with [DATE] datatype, in template it is mm/dd/yyyy format and it copying correct, but when there is [DATE] value in NULL in table, its copying like '1/0/1900', i want to to make it blank in excel file.

   

   

  how to do it?

   

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80411

  More actions

  July 28, 2019 at 2:10 pm

  #3666606

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.