david.morrison-1035652 (3/30/2010)

---

you need to put double backslashes in all paths I've found as ssis treats a single backslash as an escape character, you double them up to aviod this.

Phil, I like your FOREACH suggestion, although surely this would be better for multiple files?
We're essentially doing the same thing just different ways, the only differnce being I didnt suggest to put a file move task at the end

Gangadhara MS (3/30/2010)

---

Hi,

Should i use a File transfer task at the end to move the inserted file to another folder.

My initial requirement was in the common folder i will receive dially 1 XML file from FTP, i need to insert that latest XML file into DB.thats it.

OK, I doubled up on the slashes within the path, and put four slashes at the beginning to indicate the UNC path. My expression evaluates to this.

\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_IUXA9_PRE_20121101_888888.txt

I set the connection using this variable to delay validation as the file won't exist until I do the export. I set TextQUalifier to ", ColumnNamesInFirstDataRow to True, Format is Delimited, but don't see where to indicate that it is comma-delimited.
I set ValidateExternalMetadata in the DataFlow task to false - this file will be created at runtime.

I am getting this error (abbreviated)

Error at Export DAT [SSIS.Pipeline]: "component "Source - DAT view" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".



What can I do to make this work?

I'm using a variable to hold an expression that will set the file name at runtime then export data to the new file name.

Can you advise me?

Colleen