Dynamically Changing the Destination Excel File

• Joseph Victor

  Grasshopper

  Points: 17

  More actions

  May 18, 2004 at 4:23 am

  #59709

  HI,

  I want to write a DTS package, which will create an Excel file. I am using a stored procedure in SQL server as the source. Based on a parameter, the Stored procedure will return different set of columns. How can I create a DTS job, which will create the Excel file dynamically based on the Columns returned by stored procedure. Can any one help me.

   

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 18, 2004 at 5:17 am

  #506755

  Based on that I would write a simple VB Script to do the work and put in an Active Script in the package. Sorry don't have an example right off thou.

• Joseph Victor

  Grasshopper

  Points: 17

  More actions

  May 18, 2004 at 5:55 am

  #506758

  Thanks,

  Do you mean to, write a Vb script and connect using ADO and explicitly write into excell file?

  I tried creating a Activex Script for transfomrations. Did the column to column mapping individually for different cases. But it is not working.

  -joseph