August 11, 2011 at 12:37 pm
Hi !
I am trying to deploy the SSIS package to file system and i enabled the package configuration and i was trying to configure the Package to XML file. In my package i do have variables,executable,connection managers and every thing and i selected all. but i was getting the error message as below . My question is do we need to configure the SSIS package ? for deploying ??? and if so why is it not allowing me to configure the variables ?and what happens if i don't configure package and just build the project and deploy it ?
thanks in advance for you suggestions 🙂
Property "Value" with type "Object" of variable "User::V_xxxxxxxx" can not be exported to the configuration file.
August 11, 2011 at 12:49 pm
Creating a configuration file is one way of making deployment easier. You would be able to make changes to the xml file and just run the package against that xml file. No more need to alter the internals of the package.
That said, it is not required. It makes life a bit more difficult and will consume more of your time. But you can deploy without that config file.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 11, 2011 at 3:11 pm
So With out Package configuration Step we can successfully deploy the SSIS Package right ?I was under the impression that with out the Package Configuration Step we may not be able to deploy package with Variables,Connection strings ..etc .So i am going ahead with SSIS Package Deployment with out package configuration Step then .
Thanks a lot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply