Hi I tryied creating my first package in SSiS and i am lost in problems. Firstly , i am not able schedule the package with the connection to JDE sustem.how ever if i run it through GUI it runs fine. Secondly, when tried to create configuration table, it say, " Could not complete wizard actions", Also it says, cannot insert configuration information into the configuration table". Some time back i was able to create it, but now it some how not creating. Can any help me in this regard.I need to move it to production by 2 days.. Please help me

What is this JDE (I assume JD Edwards ERP, yes, no?)? And when you say "not able" then what error do you get? I am guessing you are trying to sore your configuration in a table in a SQL Server database, and the error is due to lack of connectivity and/or user rights to write to the target. Thus rectify your aforementioned issue.Arthur My Blog

Like what sead4711 said, it could be the length of the configuration is the culprit. Most of the time it happens for the ConnectionString, check your connectionString and be sure that the Application Name is shorter or you can remove the value, it would still work. check this one, using the SQL Configuration: http://randypaulo.wordpress.com/2011/12/02/ssis-centralize-connection-repository/ Randy Aldrich Paulo MCTS(BizTalk 2010/2006,WCF NET4.0), MCPD | My Blog BizTalk Message Archiving - SQL and File Automating/Silent Installation of BizTalk Deployment Framework using Powershell > Sending IDOCs using SSIS

http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/F54FFC5B-13F5-481A-A861-885D8ACD3AA5