Forum Discussion

ChristopheFr's avatar
ChristopheFr
New Contributor II
2 years ago
Solved

Delete some characters from header before bulk load

Hello, I would like to delete/replace some characters (typically .) from headers in xlsx or csv file before loading the file in SQL Server using bulk load. Does someone has any idea ? Thanks.
  • koryknick's avatar
    3 years ago

    You could specify the complete or relative path of the other pipeline in the Pipeline property of the Pipeline Execute snap. For example, if I was in “KoryK/examples/test1” pipeline and wanted to execute “KoryK/support/example4” pipeline, I would simply put “…/support/example4” in the Pipeline property.

    Note that the calling pipeline would not complete until the child pipeline completes, even if it doesn’t use the child execution response.

    It is preferred to execute a child pipeline using the Pipeline Execute snap, but there are use cases where calling via REST Get will work, especially “fire-and-forget” scenarios, as you are describing. Passing pipeline parameters via the REST Get can be done through the Query Parameters setting in the snap.