Thanks for the feedback.

Regarding SSIS, I have yet to work in any environment that really seriously uses it. I worked at a major company in the travel industry and...

So I think this is an account issue with Powershell trying to access Excel via a launching user. While i'm not sure that I quite understand the mechanics of...

Excellent for you. I ended up going outside of SSIS in general and doing the extraction with Powershell which gave me no problems.

I just don't get SSIS.

Hey Guys,

Thanks for all of the responses. What I ended up doing is convincing the team to do something a bit different rather than trying to capture file...

I've been contracting but have been FTE at various companies. The upside to contracting is that you get your hands on lots of different tools and exposure to different...

chadlau11 (1/5/2015)

I use the article to copy the target files from subfolders to a target folder.

Then set the connection configuration to import the dbf file from the target folder to...

Folks i'm dead in the water here - can anyone help at all? Nothing I try works and I have a feeling i'm overlooking something very simple.

Thanks for the reply -

I already have a variable which iterates through the file names on the ForEach container - this is how the data from the files is...

Thanks, all. Frustration had reached it's boiling-point and I wasn't seeing straight. I have never had the sort of issues with SSIS as i've had in the past...

So I took this out of SSIS and am using Powershell to do what I need. Seems to be working fine now. My organization prefers SSIS, but it's...

Calling 7zip from the command line works, it extracts the file as expected. I have included 7zip in the list of environment variables. It also works when I...

I should mention, too, that when I enabled logging it returns empty for the particular task in question. Aye...I have no idea how to resolve this. Usually stuff...

I'm having issues unzipping .gz files with 7zip, myself. I didn't realize that 7za.exe was something to look out for? I'm using 64-bit system as well. Hhhhmmmmmm....i'll...

Just for kicks, I created a SQL Job Agent and called the two .cmd files in their own job steps. I get the same result as with the SSIS...

The actual error i'm getting is below:

Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "C:\Program Files\7-Zip\7z.exe" "e C:\EDWDataExtracts\AWS_S3\abtest_0*.txt.gz" at "C:\EDWDataExtracts\AWS_S3", The process exit code was "2" while...