Post reply

Script to generate 100 records in a single xml file

  • December 18, 2010 at 9:41 pm

    #242534

    Does anyone know how to write XML script for generating 100 records at a time using loops in the Script Task Editor in SSIS?

    Any help would be great.

    Thanks,

    Anup

  • December 19, 2010 at 7:17 am

    #1264440

    Some background information would help: why are you doing this? Please give an example of the layout you want to create. What are the inputs/variables?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 19, 2010 at 10:15 am

    #1264448

    I want to separate the products manufactured by the company. So, I want to view 100 products at a time. The inputs are the variables that would give me the status of the product. Based on this status, I have to separate out the products in the xml file. I think I have to use a for loop in this.

    Try

    Dim cnt As Integer

    cnt = 0

    For cnt = 0 To 100

    xmlMessage.Append(AppendProduct(Row.Name, Row.Category))

    Next

    'While (Row.NextRow())

    ' cnt = cnt + 1

    'End While

    I need to know the exact thing that would give me 100 products in this.

    Thanks,

    Anup

  • December 20, 2010 at 1:51 am

    #1264519

    Where are the products stored? In a table in the database?

    You really need to give us more information if you want people to help you. We cannot read your mind.

    Make a short example of what you are trying to accomplish.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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