SQL Server 2005 DTS /SSIS

#41

Test Test wrote:

Quote:

No, it for columns mappings. In DTS 2000, you have a choice to map 1
source coumne to 1 target column / or you can select all columns
(source, target), choose copy and apply mappings in a single
transformation (click on Transformation tab under Transform Data Task
Properties). The processing goes faster using a single transformation.
In SQL 2005, I can map 1 to 1 but I can not select multiple columns.

I don't know DTS 2000, to be able to help you, you should describe
in more detail what you are trying to do with SSIS.

As far as I understand you are trying to copy data from source to
destination. In this scenario you don't need a transformation in
SSIS at all. All you need is a data flow task with a data flow
source and a data flow destination component.

regards,
Gerald

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 DTS /SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SQL Server 2005 DTS /SSIS - 09-16-2008 , 02:10 AM