I'm trying to find some good direction on the following:
I'm creating a dynamic BIML process that will generate multiple packages within a solution. There is a dataflow task that will move data from a source to a database. I'm trying to build this where each package will have a different file, and possibly different configuration for the file, delimted vs fixed, etc.
It looks like I can only define the connections under the BIML root?? This works for project level connections, however if I generate 10 packages, then they will all have 10 file connections. Am I not able to create a package level file connection within the Package tags? I know there is connections, but it will only let me reference a connection already defined at the higher level? The same goes with defining the format and fields, I can only find examples where the format is defined outside of the package tags?
Any direction or example references would be greatly appreciated.