If your end intent is to load this CSV (so it is an all dynamic oepration) into that table then the SSIS package better be built dynamically in .net code.
The steps roughly are:
- Create a Console C# or VB .net project, reference the DTS dll, and
- Have the code inspect the columns for quantity, size and content, then finally
- Generate and run the package built by the code
An post with relevant links: http://consultingblogs.emc.com/jamiethomson/archive/2007/03/28/SSIS_3A00_-Building-Packages-Programatically.aspx
a more specialized example: http://blogs.msdn.com/b/christophputz/archive/2010/03/04/creating-ssis-packages-dynamically-from-template-packages.aspx
PS: I proposed this solution because designing SSIS packages using SSDT/BIDS/VS requires static metadata. And you also need to inspect the content to determine the length of the columns, not all may fit into the target.
Arthur My Blog
