About Connections and component mappings

1.After creating pacakages what i am concerned about is that when i move then to different locations do they work just the same as the had been.

2.About the mapping with in the components like lookups,and the variable with in conditional split or etc....do they get disturbed with any change in the location of the textfiles or anything of this kind of location change.

3.Is is adviceable transforming 5 to 6 text file with in one package in parallel

Please let me know

Thanks

1. They should work the same way. Just make sure the account executing the package has required permissions on all enviroments; but that is nothing to do with the package itself.

2. Same as above

3. That may be a matter of taste. I rather preffer to encapsulate an smaller set of functionality. A packag per every flat file may be; they could be run in parallel anyway.

|||Also, for #1, you can use package configurations to allow for easier maintenance of the file paths.|||

How can i use package configurations?For easier maintenance.How dod i do it.

Please let me know.

|||

Package configuration allows you to virtually overwrite any object property within a SSIS package. It comes very handy to deploy packages to different environments as you can override connection strings, paths; variable values; etc.

Here are a copule of links that talks about it:

http://msdn2.microsoft.com/en-us/library/ms141682.aspx

http://www.sqlis.com/?26

|||Keep in mind that a package is just an XML file that can always be opened in "notepad". Any concerns that you have could be resolved using ctrl F.