January 27, 2010 at 7:47 am
I've created a package which imports 6000+ files into a table and now I want to export them and see if I can view the files.
I'm trying to use Derived Column and Export column to export but am having a few errors and the process is not working, the file types of all the files in the table are different so I have a column in the database which stores the path and one for the name.
I have several problems, the OLE DB Source fails but doesn't give me any errors but it only manages to process just ove a third of the files, the derived column task is successful although I'm not sure about the settings and then the Export Column fails with the errors below:
[Export Column [76]] Error: Opening the file "g:\export\files\file.xls" for writing failed. The file cannot be found.
[Export Column [76]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Export Column" (76)" failed because error code 0xC020909E occurred, and the error row disposition on "input column "NewFilePath" (83)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Export Column" (76) failed with error code 0xC0209029 while processing input "Export Column Input" (77). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
[OLE DB Source [1]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Does anyone know of any tutorials as I'm working from a Wrox book but it only has one example where you hard code the file extention which is no good for what I want or can anyone give me any advice on this?
Is there another way apart from Export column of viewing files stored in SQL Server? Is there another way to stort them apart from Import Column? How do I know if they are stored correctly?
Thanks
January 28, 2010 at 4:45 am
Worked out what it was, in my path and file name column I have quite a lot of different folders, listed, eg G:\folder1\folder2\file.xls, folder1 existed on the disk but folder2 didn't, when I tried to just extract to G:\folder1\file.xls it worked so the Export Column task will create the files but if the folder doesn't exist it doesn't create this, so the folders will need to be created before the export.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply