A
Andreas Palm
I need to load a txt file into SQL server, so I have to use a
schema.ini file.
Unfortunately MS decided that in this schema.ini the name of the file
that gets sucked in has to be hardcoded. So I decided to read the file
in an array and then change the first line, write out the rest to a
file again. Now all this works fine, however just after writing this
schema.ini I try to fetch the text file in SQL and now in the
background this schema.ini has to be used. But
it complains that the file is locked by another process.
Here is my code
FileInfo t = new FileInfo("schema.ini");
StreamWriter Tex =t.CreateText();
Tex.WriteLine("[" + myDA.inputGrouperFileName.ToString() + "]");
for (int y = 1; y < mystring.Length; y++)
{
Tex.WriteLine(mystring[y].ToString());
}
Tex.Close();
t = null;
I feel that FileInfo is still sitting on the File, however there is no
..close() I could use
any idea ?
regards
andreas
schema.ini file.
Unfortunately MS decided that in this schema.ini the name of the file
that gets sucked in has to be hardcoded. So I decided to read the file
in an array and then change the first line, write out the rest to a
file again. Now all this works fine, however just after writing this
schema.ini I try to fetch the text file in SQL and now in the
background this schema.ini has to be used. But
it complains that the file is locked by another process.
Here is my code
FileInfo t = new FileInfo("schema.ini");
StreamWriter Tex =t.CreateText();
Tex.WriteLine("[" + myDA.inputGrouperFileName.ToString() + "]");
for (int y = 1; y < mystring.Length; y++)
{
Tex.WriteLine(mystring[y].ToString());
}
Tex.Close();
t = null;
I feel that FileInfo is still sitting on the File, however there is no
..close() I could use
any idea ?
regards
andreas