July 24, 2009 at 11:42 am
I am looking for a standards document for SSIS. Is there one like that somewhere ? Please advise.
July 24, 2009 at 12:29 pm
I have some recommendations but not a whole doc..
1. Packages are deployed into SQL Server, this allows them to be backed up with the SQL data and does not require a coordinated backup of the File System.
2. Package Execution is tracked in a logging mechanism, primarily the start, I capture start time, package name, package major and minor version and very importantly, Version Build. What this allows me to do is to tell what version a package is everytime it runs. Version Build is incremented everytime the package is saved, and while you can overwrite it to what you want, it is a way of telling that something has changed without any real effort.
3. For servers that have packages that have 32-bit dependencies I put them in their own project, seperated from the packages that don't care.
4. Use project datasources anytime you are going to have multiple packages that tend to use the same connections.
I'm sure there are more but thats just what I got off the top of my head..
CEWII
July 25, 2009 at 2:47 am
Hey,
These are some good Conventions used in our project, we got from the below mentioned link
October 20, 2015 at 6:10 pm
Hi does any one have another source of SSIS Standards. I need to create document that my company will follow for all new coming projects. PM if you can share a doc of some kind.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply