July 28, 2020 at 9:03 pm
SQL Server Data Tools 15.1.62002.01090
Microsoft Visual Studio Community 2017
Version 15.9.21
I am loosing dtsx packages! It happens sometimes when i am closing a solution and sometimes when i build the project. The packages are actually deleted from file and are no longer avaialble. They are just deleted. What is happening? Has anyone else seen this?
Desperate!
July 28, 2020 at 9:09 pm
I'd check in the project directory in Windows Explorer to see if the missing package files (*.dtsx) are there. In all likelihood, the files are there, but aren't listed as part of the project in your Solution Explorer view. This can happen if you accidentally close the project without saving, or if Visual Studio crashes in the middle of an operation.
If the .dtsx files are in the project folder, you can just import them back into the project by clicking the project and choosing Add -> Existing Item (I think that's the menu selection label).
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
July 28, 2020 at 9:19 pm
I have not seen package files disappear, though I've certainly seen the text in Script Tasks disappear in the past.
Hopefully you've got source control (even if it's just a local git repo) set up to help you manage this, now and in future.
Also, I have seen cases where packages have been created or deleted but then the corresponding project file has not been saved / checked in. In these cases, the packages listed in Windows Explorer will be different from the packages listed in the VS Solution Explorer.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 28, 2020 at 9:49 pm
If you are running Windows 10 and have it stored in your profile, that could be your problem. I've had files (not specifically dtsx files, but pictures) just disappear on me. For me, it was photos that disappeared. I would edit one (adjust the white balance, contrast, sharpness, cropping, etc), save it, move onto the next one. Did about 30 or 40 photos this way, hit save then went to load the next and got told there was no next. I SHOULD have had about 400 photos in there, but it told me I had 0. Went and looked and they were all gone. Thankfully I had backups of the originals on a NAS so didn't actually lose the photos.
Might not hurt to do a virus scan and a check disk on your drive as well. Could be a sign of hardware failure or a faulty drive. I've had problems like that when I bought cheap USB drives from China before. A 256 GB USB drive that once you put more than 4 GB on it, files start to disappear on me. There are tools that can be used to check these, usually done by writing a 1 GB file to disk then reading it back and repeat until your disk is full. I wouldn't run that on an OS drive though as that'll cause all sorts of problems for you.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 29, 2020 at 8:41 am
I have not seen package files disappear, though I've certainly seen the text in Script Tasks disappear in the past.
Ahh, don't remind me of that "feature"! I lost so much work when that first started happening. >_<
I agree, I've never seen this behaviour either; this sounds like something else is happening in truth but going to be difficult for us to really tell. I agree that source control software is a must though, for nothing else but recovery. The fact that it's happening on closing the solution and deploy is very odd; as they are completely unrelated tasks. You aren't, perhaps hosting the files on a network share, are you?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 29, 2020 at 12:05 pm
Thanks everyone for your replies. I really appreciate them.
The files are actually gone from disk, not just the project. Really frustrating.
I am working over a VPN (aren't we all?) to a mapped drive at my company.
I have a day old backup to add to the project bit there goes a days work.
Jonathan
July 29, 2020 at 12:15 pm
I am working over a VPN (aren't we all?) to a mapped drive at my company.
I'm working over a VPN, yes, but I'm not working with projects that are stored remotely; the files are stored locally. I would suggest the problem is because you are working with files that are stored remotely over the WAN, and not locally. The part that's not lcoal would be when you commit said files to the source control server.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 29, 2020 at 1:34 pm
Thanks Thom and everyone. I am going to try the local files with remote GIT source control.
July 29, 2020 at 5:50 pm
I am going to try the local files with remote GIT source control.
The way I've been working for the last few years is to have the 'remote git' part hosted in the cloud (I've used GitHub, Bitbucket and Azure DevOps for this) and to have local clones of the hosted repo's I need to work on.
All source code changes happen locally and are committed locally, before being 'pushed' to the remote host. After being pushed, other users can then 'pull' these changes into their own local repo's.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 29, 2020 at 7:14 pm
I had no idea how badly working over the VPN was degrading VS and SSIS. Now that I working on local files and syncing them with DevOps GIT source control life is good! I have spent the day recreating the lost files and uploading my project to Azure.
No more spinning "VS is not responding" for a simple save, builds take seconds instead of minutes. Thanks for all your suggestions,
Jonathan
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply