![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#3
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#4
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#5
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#6
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#7
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#8
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#9
| |||
| |||
|
|
On Jun 26, 11:56 am, Holger Voges <hvo... (AT) web (DOT) de> wrote: Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting maybe your application flags the file as used or locked, so you can view it with notepad or with ssis designer. I would make a test using a copy of the file and editing connections in the ssis package in order to use the duplicate. |
Is there any chance to force the flatfile-source to open the
#10
| |||
| |||
|
|
Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I can access the archived log-files without problems and I can preview (!) the actual log in the SSIS-Designer, but I get an error that the acutal Log-File is in use by another user when I start a debug-run of the package. Has anyone an idea how to access the contents of the file so that I can import the data for analysis-purposes? Greetings, Holger --www.netz-weise.de Training und Consulting |
![]() |
| Thread Tools | |
| Display Modes | |
| |