I am learning SSIS. Had a question regarding the same. I have a SQL Table
`(File id, File name, File content)
(1,abc,hi)
(2,ghi,how)
(3,ghi,you)`
I want to give an input in SSIS: File ID and Destination Folder Output: I want to export 'File Content' in the destination folder as FileName.txt.
Example: From the above table if I give input as
File ID=1
I want all the files
(file ID>1)
in the destination folder as
abc.txt
def.txt
ghi.txt
having the respective File Content in them. Can you please help me with this? I have trued using Script task but its not giving the right output. Thank You!!
