SSIS can't copy view, SP, UDF

#1

After I defined a transfer SQL Server object task in SSIS, I find there is
no any object appears in destination database, could you tell me what
configuration I must set?

#2

Hello Johnson,

Is the only thing you have checked to transfer the proc itself? Try selecting
"Copy Schema" as well.

Allan

Quote:

After I defined a transfer SQL Server object task in SSIS, I find
there is no any object appears in destination database, could you tell
me what configuration I must set?

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

SSIS can't copy view, SP, UDF

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

SSIS can't copy view, SP, UDF - 01-18-2006 , 07:11 AM

Re: SSIS can't copy view, SP, UDF - 01-18-2006 , 03:38 PM