Search code examples
ssisssms-2014

How do I get rid of the CreationName Error in my SSIS package in SSMS?

I have created an SSIS-Package, which is supposed to import Data from Flatfiles (txt. Files) into a Database. When I execute the package via Visual Studio (Enterprise, 2015), there are no problems and everything works just fine. The problem occurs when I deploy the package into SSMS (Express, 2014). When I execute the package from SSMS, I get an Error (no idea if there is an Error Code or where to find it) concerning the property "CreationName". SSMS doesn't seem to give me any other information. In the package are 5 scripts, which all do the same but with different flatfiles. They all get this CreationName Error.

Has anyone any idea on how to fix it or the source of the problem?

enter image description here

Solution

  • i solved the problem, but it had nothing to do with the creationname apparently - i made some wrong settings in my sql agent + i made it work by deplying it from my hard drive instead of the virtual drive. I also had a typo in one of the scripts :x Idk why it had problems with the virtual drive though; maybe it was an authentication problem. Still THANK YOU ALL SO MUCH! You guys kinda brought me there :)