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?
Who is Participating?
srnarConnect With a Mentor Commented:
What does it mean:"column name changes"? Does your SP return different number of columns (e.g. PIVOT) -  or you need to export different header column names into CSV?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.