travisrail
asked on
Dynamic Column Names in SSIS Package for MSSQL 2005
I'm trying to create an SSIS package that will run a stored procedure and export the results of that stored procedure to a CSV file. The problem I am having is that each month the column name changes and so I am having a hard time mapping the columns between data sources. Is it possible to create a SSIS package for MSSQL 2005 that allows for dynamic column names instead of static names?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.