Solved

Questions regarding SSIS

Posted on 2013-01-14
1
160 Views
Last Modified: 2016-02-10
Hi,

I have a few questions regarding SSIS:

1.      Which is considered best practice, a static table definition or a dynamic table definition? We’re talking about a dimension table. My guess is the former seeing as how you need to map columns from source to target tables. Unless, of course, there’s a mechanism that would  automatically propagate missing columns?
2.      Can SSIS handle TEXT fields, propagating any size data? For replication, there is a configuration on the maximum size of a column to replicate. Are there any concerns for not setting an upper limit?

Please advise.

Thanks
0
Comment
Question by:Sonali Paradkar
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 38776434
1)  Static, as any time the previously-defined source is different from the runtime source SSIS attemps to force a complete remapping.

You can use SSIS menu, Package Configurations... to change the source server/db of the table, but it still has to have exactly the same column definition.

2)  Handle text fields yes, any size up to 8k I believe yes, but if you're not certain I'd set it to the max size, and then do any editing after the data is transferred to the target.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question