Post reply

Passing Variables to Create Table

  • July 10, 2006 at 4:34 am

    #67502

    Hi

    Im trying to export to an excel spreadsheet,and create a new sheet per client code in the same workbook that i have,is there any way of passing the client name eg;@client to the create table statement in the DTS Create Table Statement.

    thanks

     

     

    JC

     

  • July 11, 2006 at 12:23 pm

    #648561

    How many clients are we talking about?

  • July 12, 2006 at 12:45 am

    #648633

    It varies and can be random, i would create a pump for each client,but i dont want to hardcode as clients could increase or decrease.

  • July 12, 2006 at 12:52 pm

    #648796

    This is tricky. You will have to read up on adjusting the DTS CustomTask SQLStatement properties using ActiveX. Or if the create table command will never exceed 255 characters, you can do it using the Dynamic SQL task.

    And you definitely need to know how to loop a DTS workflow using ActiveX. The other question I have is how do you get your list of clients into the DTS to start with? Is it a SQL table, a CSV file, or what exactly?

Viewing 4 posts - 1 through 3 (of 3 total)

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