Blob to ADF to Stored proecure

  • SQL_Surfer

    SSCrazy Eights

    Points: 8080

    I'm reading file from BLOB through ADF and I would like to pass the whole content of the file to stored procedure..Is it possible? If so,  can somebody give me some pointers? Thanks.

  • SQL_Surfer

    SSCrazy Eights

    Points: 8080

    I am using Lookup Activity to connect to Source file and trying to pass the whole content of the file through parameter of stored proc as a string. Stored proc loads the content to the table.

    But this is what's being loaded in the table instead of the content of the file.

    System.Collections.Generic.Dictionary`2[System.String,System.Object]

    Any idea would be appreciated.

     

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

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