SSIS Copy Column

Question

SSIS Copy Column

Viewing 7 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

Maybe you are getting confused.

The Copy Column transform creates an in-memory copy of a column in your data source, which you can use later on in your data flow.

It does not do any DDL. What are you trying to achieve?

aprasy Mr or Mrs. 500 Points: 571 More actions · Answer 2

Mr. Phil Parkin could you clear me. I cant understand your concept.

Thanks

Pras

Phil Parkin SSC Guru Points: 247183 More actions · Answer 3

Sorry 😀

Please explain in more detail what you are trying to do - it is unclear from your original post - and I will attempt to describe how it might be achieved in SSIS.

Phil

aprasy Mr or Mrs. 500 Points: 571 More actions · Answer 4

Actually i had a table in database, i used this table in copy column editor to add a column in that table. But i couldn't do that. Are you clear now?

Pras

Phil Parkin SSC Guru Points: 247183 More actions · Answer 5

So you are trying to add a copy of an existing column to an existing table?

This sounds like a one-off design task - why are you thinking of using SSIS to do this? Will you want to copy a certain column many times?

It's easy enough using T-SQL, if you really need to do it.

The Copy Column transformation does not create anything new at the database level. It merely adds a new column to the data pipeline which is running through memory. If you want to use or store that new data somehow/somewhere, you have to add additional processing to your package to do so.

aprasy Mr or Mrs. 500 Points: 571 More actions · Answer 6

aprasy

Mr or Mrs. 500

Points: 571

April 30, 2009 at 12:16 am

#986453

Thanks

rinkalams.c SSC Journeyman Points: 78 More actions · Answer 7

rinkalams.c

SSC Journeyman

Points: 78

April 14, 2010 at 6:31 am

#1151278

:-):-D