April 29, 2013 at 4:12 am
Hi I have an issue .File is not loading from the source .Flat file source is the source
[Flat File Source [656]] Error: Cannot open the datafile "G:\er\inbound\upsirpt\soup\extracted\delimited\*test1.*.dat".
April 29, 2013 at 4:15 am
I do not think that the wildcard character * is valid in file names - assuming that that is your question?
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.
April 29, 2013 at 9:45 am
Yes. how to process this file
April 29, 2013 at 10:52 am
Smash125 (4/29/2013)
Yes. how to process this file
That file does not exist. Remove the wildcard characters and use the real file name.
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.
June 6, 2013 at 5:55 am
Use expression to build the complete file name, if you want to make it more dynamic
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply