November 19, 2013 at 8:52 am
Hi
I have a number of datasources i need in a SSIS package and the specifications are listed in an excel file.
I could create each of these data sources by hand but id rather import them from the excel file all at once. Is there a way of doing this does anyone know?
Thanks in advance
November 22, 2013 at 5:22 am
Hi,
Not that I've heard of.. You could insert the connections in to a Config database and then use them as project level data sources in BIDS so that any SSIS packages you create will have access to all of the connections without having to use separate package configurations..
Jim.
November 22, 2013 at 6:03 am
can you add field lengths and positions in the connected files in the config file?
November 25, 2013 at 10:00 am
If I understand what you are asking, and this is not an exact answer without seeing your exact requirements
but - yes you could store that information, however you would need to set the values before run time. The best way to do this is to have a parent-child package scenario, where the parent loads the parameters from a config table, and sets the parameters in the child on calling that so it is compiled with those parameters at run time
Another option is to create the package programitically where you can set all the elements individually in code - Start with the following
Hope that helps
November 26, 2013 at 1:15 am
SSIS doesn't really support this natively, but you can use BIML to read the metadata from the Excel file and create the data sources for you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply