Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
 Posted - 2007-03-30 : 16:53:53
|
| Hi,I'm kind of the first person at my new company to start a project using SSIS. My question(s) revolves around setup and configuration, maybe even best practices.1. Connection Manager Config - What are some of the methods you use to config your connection managers? I was planning on creating a folder (C:\SSISConfig or something) and keeping a config file for each connection there. That way it would be fairly trivial for each developer to also put said folder on there box for deving.2. Solution set up - Are people creating solutions for each package or just using one Master solution and adding all the packages to that? Or maybe some combination, like having solutions for different areas of functionality or something..? I'm trying to figure out what the pain points are with different approaches.If you have any other information or horror stories about SSIS that you think might help, feel free to pass them along.Thanks,-Ryan |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Config