Yep, realizing that now, we are just going to encrypt the data as soon as it hits SQL Server.

thx

so the export gave you an ISPAC file correct? Then did you create the project from that file?

You can do that by creating a new project choose SSIS...

yep that did it, I should have seen that, was focusing too much on the encryption part. 

Really appreciate the help, have a great day!!

yeah feels like it, but not sure. how did you get the package from the server? dtutil.exe or was it on the file system? 
Also, do you know what version?...

Hi Gail,
It's  VARCHAR(15)

I've opened a couple packages and looked at the XML, i checked a 2008 and a 2016 package and both start with the same line:
<?xml version="1.0"?>

what do...

Thanks everyone for the replies I see there is a common theme here and i tend to agree that i'd rather not be surprised if something did fill up. 
Instant...

OK, but that could be variable percentage based on the number of files used unless you meant that based on having 8 files. 
Also Auto-growth will be turned off since...

Hey Jeff,
I feel that is good advice. I'd like to know why it happened but i guess if i can get to the point where it doesnt happen again...

Nope, I mean DNS (Domain Name Servers).

When i connect to ACME.SQLSERVER01 it will hit DNS to get the IP and then route to the correct server. I...

Thanks Sue,
I've removed the linked server since I've found some posts regarding issues that reference linked servers.
It appears so far that its been the last 3 Sundays,...

I dont see any dump files (.mdmp) files.
for the time in question there are multiple .LOG.1 files(from full text indexing operation), a SQLAGENT.1(shown below) and a system_health_.... extended events...