August 6, 2015 at 3:31 am
I had read through alot of article about this issue, but i tried all the methods, I still facing this issue.
Currently, I have 2 server - 1server is APP and 1server is database.
I created a shared folder in APP under local disk D(D:) and name the folder is Testing. Then, I go to database server and map the driver to [servername]\Testing under Z: driver.
I created the SSIS package, in this SSIS package i had place the flat file destination and i place the file under the
"Z:\\DatabaseSizes_" + (DT_WSTR,4)DATEPART("yyyy",GetDate()) +
RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) +
RIGHT("0" + (DT_WSTR,2)DATEPART("dd",GetDate()),2) + ".csv"
So, I imported the SSIS package to MS Server 2008 R2 Integration Servvice > Stored Packages > File System
I create a job under the SQL Agent Job and call the SSIS package.
After I run the job, the job failed and the error is cannot open the datafile.
August 6, 2015 at 3:34 am
Yes, It facing the same problem, if I run from the SSIS package, But if I change the directory to local, it does not face the problem.
August 6, 2015 at 3:43 am
I already put the access to 'Everyone'. But still facing the same error.
2server are located different IP and Port.
August 6, 2015 at 4:06 am
Problem Solved by using UNC Path to do the file location.
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply