Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Questions regarding SSIS

Posted on 2013-01-14
1
Medium Priority
?
172 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 P
1 Comment
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1500 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

564 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