I figured it out. I went into the Expressions for the Exe SQL task and set the SQLStatementSource to the following:

"Exec uspDatafileExists " + @PrefixVariableName + "inscode_t"

sorry, didn't notice the post was going to the 2nd page

I thought I found the issue. I delete the files that were there from when I unzipped it by right clicking it and reran the script and recieved the not...

Ok, I thought I found the issue. I'm getting an error message stating

Program aborted

NULL

There is not enough space on the disk.

But I know there is enough space, I just...

Found the issue. When I scrolled down to the bottom of the returned messages there was an error message stating that there isn't enough space for all of the files.

I believe so. When I run it it returns messages saying its extractiing the files

yes

I rant the script but it returned a null

How can I find that out?

Many Thanks Martin.

On your Exe SQL task under the gen tab are you setting the result set as single row?

Also, In the EXE SQL task under the ResultSet Tab, are you changing...

Thanks, I pasted the truncate in front of the drop index statements and it sped the process up a good bit.

Ok, thanks. Good to know for future reference.

I found a workaround, I first moved all of the files with the .txt extension using the regex "FileName*.txt" then used the foreach loop container to grab the ones I...

Fixed it by concatenating a space on the end of the value when the length of the value was 3. All of this inside a derived column transformation