No, the file is not open.
Can you try to download once and try if you have a chance please( it is a public website and anyone can download the...

I have a quick question on this.
When I run the solution from Visual Studio, I am not facing any issues but when I deploy the project to Server and Run...

Thank you so much, Frederico Fonseca.
I did try with 2 files and it worked like a charm.
You are really a saviour and Thanks for putting a lot of effort...

Thank you for your time Frederico.

Spoke with them and was told that this is the only format they hold the data, Frederico.

Thanks for the reply, Frederico.
Sure I will donate to Saint Jude's children's cancer research institute.

Sorry, I did not understand what u said about the comp-3 fields.
The Texas state department...

Hi Frederico,

I tried this method but looks like I am not doing it properly and I am getting blank data loaded.

Can you please help me on the c# ( I...

Hi Jeffrey,
I did not get what u meant by you cannot see the data in the file.
Do you mean you cannot download the file -> 

October 15, 2018 at 3:54 pm

#2009763

Phil,
So should I write the expression like this now?

I am using 7zip.

Frederico,
I think you are right. The Server on which the Job is running doesn't have Internet access.
I did raise an SR to grant me access and when I...

Patrick,
I am using the SQL Server Agent Service Account to run my job.
As I told, I am able to run a different step(In the same job) which loads data from...

Srikanth,
Permission is not the issue because I am able to run other packages and I am the Admin on the server.

Smendle,
Attached is the full error message...

Yes you are right. It needs to be resolved on the source side but i am getting this file from a state government website and I am not sure how...

What I don't Understand is why some of the data is getting loaded properly and not the other.
For example the below two records are loading properly
"33105000040000","25","AMERADA HESS CORPORATION","BEAVER LODGE-DEVONIAN UNIT ...