It would be a better idea to partition the database table to accommodate future growth in terms of columns. That means column partitioning so that the data rows are stored...
I would solve this issue by using a database table to store parameters to be passed to the stored procedures. You can also store many params for your database application....
Verify if you configured the text file source properly. And also check for the source to target mappings as well. SSIS pretty much does everything if you configure the source...
The best way to solve this issue is to create a view or stored proc in database one by referencing (joining) to the table in the second database. This...