March 15, 2011 at 9:59 am
Hi all,
I have created a package to send a file via FTP to oracle server and released to production successfully.
but now oracle FTP and username changed and they want me to test it using new IP,UserName,Password.i have stored them in tble configurations like before and started testing it but i am getting this error,which is not giving me any clue .can anyone tell me why i am getting this so that i can proceed..
Executed as user: abcd\sqlserver. ... 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:10:29 AM Progress: 2011-03-15 08:10:33.71 Source: Data Flow Task Validating: 0% complete End Progress Progress: 2011-03-15 08:10:33.76 Source: Data Flow Task Validating: 50% complete End Progress Progress: 2011-03-15 08:10:33.78 Source: Data Flow Task Validating: 100% complete End Progress Progress: 2011-03-15 08:10:33.84 Source: Data Flow Task Validating: 0% complete End Progress Progress: 2011-03-15 08:10:33.85 Source: Data Flow Task Validating: 50% complete End Progress Progress: 2011-03-15 08:10:33.87 Source: Data Flow Task Validating: 100% complete End Progress Progress: 2011-03-15 08:10:33.87 Source: Data Flow Task Prepare for Execute: 0% complete End Progress Progress: 2011-03-15 08:10:33.87 Source: Data Flow Task Prepare for ... The package execution fa... The step failed.
March 15, 2011 at 11:45 am
I found the error when i ran ssis package on the server (our server) .
The error says we cannot create the file if the file already exists on the destination server even my code overwrites it so i deleted the file and ran the package it worked perfectly.
I have also mentioned it to the oracle team so that they will look into the issue because i will be running into the same issue again.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply