create repot in a new excel named with a current date on every run of package

  • i want to create report in a new excel named with a current date on every run of package.

    means when i run a package a new excel shud create with a current date name and my data returned by querrry shud be in excel hw will it b done in ssis

    thank s in advance

  • and also we should make delay validation to true for the excel connection manager, correct me if i am wrong.

  • Sir i am the beginner in ssis packages

    can u please make it elaborated explaination, this will happen in control flow or data flow?? and in which task???

  • Sir i am the beginner in ssis packages

    can u please make it elaborated explaination, this will happen in control flow or data flow?? and in which task???

  • in which task??

  • i have deployed ur demo packeg, varibles created auto matically, excel connection manager is there, bt i want to execute a query and stor the result in a new excel always when packege runs, so which task shud i include

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply