September 18, 2008 at 10:34 am
I have a daily transfer where we populate a text file on a daily basis, then the file is sent via FTP to a client. I am trying to use the Flat File Destination Data Flow task, but it requires the file to already exist. How can I auto-create this file when the package executes?
Do I do this with the Control Flow tab?
Probably a basic question, but I am trying to learn things on the fly.
Regards
JJ
September 18, 2008 at 10:47 am
Hi,
I think there 2 solutions here:
1. You copy a blank template file after your FTP process. OR
2. In flat file destination property, select validateexternalmetadata to false. So, your validation dosen't fail. (Sorry, I have not tested this.)
VG
September 18, 2008 at 11:17 am
The second option worked great!
Thank you for the prompt answer.
JJ
September 18, 2008 at 11:53 am
Great!!! You proved it works......
VG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply