I have a very stupid problem, because the way BIDS works is just hilariousy idiotic.
1) When i try to edit script tasks it will complain about "failed to create project at some random path in temp folder" and wont open anything. I cannot edit script tasks anymore. THe project is essentialy dead to me. REboot or restart wont help. I spent
five hours on this project and i dont want to do all that work from scratch!
2) I cannot port my solution to antoher computer or place because it links to the files in appdata/local/temp folder of the pc for some reason. If i delete that folder or port the solution, it will complain about some file in temp folder called "3jews....tmp"
and will say that solution is unopenable.
Need help to resuce my project and be able to continue working on it!
When you make a project, BIDS stores its files in a separate folder: a solution file, a project file, a package file etc. You might have thought, you can now carry your solution over by copying this folder. WRONG! The BIDS actually stores files of the
solution in /Users/name/AppData/Local/Temp folder! And It cannot open a solution/package/project without files from that folder, now what kind of idiotism is that?
It all started with BIDS not saving my script task changes, then telling me "cannot create project in folder
View Complete Post