I have Variables declared in one package. I want to just copy the same set of variables in my next package. Can i copy the variables. If yes how ??Thanks & Regards, Bhavika

Please check here for Using the Values of Parent Variables in a Child Package http://msdn.microsoft.com/en-us/library/ms345179.aspxhttp://uk.linkedin.com/in/ramjaddu

Bhavika, If you're talking about copying the variables when developing the package, there is no way to do it (other than copying the xmla for variables from your existing package and pasting it in the new package that you are creating; however, this approach is not at all recommended since this could make your existing package go corrupt!). You will have to manually create the variables in the new package! If you're talking about copying the variables' values from the parent package from the child package at run time, you will have to use the Parent Package Variable configuration. Please refer to the link posted by RamJaddu in his reply. If your packages are not related (not parent-child packages), then, i'm afraid, there is no direct way to copy the variables' values at runtime.! One workaround that i could think of is to store the variables' values in a data file (or a database table) and then reading these value from the other package. Hope this helps. Let us know in case you need any more information. Regards! Shalin Shalin Kapadia

I don't think if there is any way to copy the variables apart from copying them from dtsx (view code and check for the variables under DTS VARIABLE tag) and pasting them into other dtsx file under DTS VARIABLE tag. But I wouldn't recommend it as there is a risk of package geting corrupted. Try to create the variables manually if you need it for one or two packages. If you have some set of common variables required in all the packages then you can define a package template and use the template package to develop your packages.Nitesh Rai- Please mark the post as answered if it answers your question