OLEDB Connection manager in SSIS
thnx Nitesh for ur reply, I wana know I have a Project in which I have 1 SSIS Packages, package consists of 500 Data flow tasks. If I need to change the Connection to the Target or Source for the Packages in the Project if i will do this by changing source and destination in each and every dataflow task than it will be a great problem its same as making of new package again of 500 Data flow tasks. I have use Package configuration and there i have created XML configuration file(Test.dtsConfig) in which i have defined connection string for target or source of the package . but how to configure that xml Config when i copy the project from one server to another, in another server how to configure tht xml again
June 23rd, 2011 8:40am

Hello All, I have a Project in which I have 1 SSIS Packages, package consists of 500 Data flow tasks. If I need to change the Connection to the Target or Source for the Packages in the Project if i will do this by changing source and destination in each and every dataflow task than it will be a great problem its same as making of new package again of 500 Data flow tasks. I have use Package configuration and there i have created XML configuration file(Test.dtsConfig) in which i have defined connection string for target or source of the package . now in OLEDB SOURCE / OLEDB DESTINATION In OLEDB SOURCE connection manager i want to create new connection so i clicked new tab . In connection manager provider there are various options for providing connection i want use my XML file which i have made above(Test.dtsCofig) i was thinking I would change package information via editing the package XML file. is there any way to do that. Also can i change the connection through XML. Thank You
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 8:46am

Go thorough the below tutorial to know how to configure package configuration http://msdn.microsoft.com/en-us/library/cc895212.aspx Cheers, Shailesh
June 23rd, 2011 8:48am

Read this below thread on how to use the XML config file in the package http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/130d670b-9c97-46aa-a52c-f3beba1c37c2
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 9:11am

I hav checked all this link before. Srry this is not an appropriate solution for my question asked above. i m askin how to use that xml file in OLEDB Source
June 23rd, 2011 9:36am

Is there any way to do that.Also can i change the connection through XML. No. You have to create the connection manager manually in the package. Through XML config file you can change the connection manager's properties (which are defined as configurable in the configuration file) . Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 12:05pm

As nithesh mentioned , you will be able to assign the connection manager proeprties in the XML config. While executing the SSIS package , before execution the values from the XML config will be read and used in the connection manager.
June 23rd, 2011 12:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics