Solved

Questions regarding SSIS

Posted on 2013-01-14
1
158 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Rename SQL Instance/SQL Developer Edition 2012 2 19
Addition to SQL for dynamic fields 6 38
sql 2014,  lock limit 5 32
SQL Error - Query 6 25
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

773 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