I'm using a "Transfer SQL Server Objects taks". These are the settings I have:

SourceConnection: ServerA

SourceceDatabase: Stage

DestinationConnection: ServerA

DestincationDatabase: TEST

DropObjectsFirst: False

IncludeExtendedProperties: True

CopyData: True

ExistingData: Append

CopySchema: True

UseCollation: True

IncludeDependentObjects: True

CopyAllTables: True

CopyAllViews: True

CopyIndexes: True

CopyTriggers: True

CopyFullTextIndexes:...

I know its been awhile, but do you remember what you did to fix this issue. I'm running into the same thing.

Thx everyone. Really appreciate all the help.

Awesome! thank you very much.

Thank you so much!

Again, thank you again everyone.

Thank you very much!!!

awesome, thanks very much! i'll give it a shot.

Thats great! Thanks for all support.

Insert into dbo.VerizonDetailsFinal ([From Number], [Usage Date], [ConnectTime], [endTime]) values ('2012593398','40172','11:54:35.0000000','11:55:29.0000000')

Insert into dbo.VerizonDetailsFinal ([From Number], [Usage Date], [ConnectTime], [endTime]) values ('2012593398','40172','11:55:34.0000000','11:56:28.0000000')

Insert into dbo.VerizonDetailsFinal ([From Number], [Usage Date], [ConnectTime], [endTime]) values...

Thanks so much everyone!

You are so Awesome! Lynn. Thank very much.

Thanks everyone, was able to get it working with set based statement. Had to loop through all the records.

00:13:00

00:01:00

00:03:00

00:09:00

00:01:00

its weird, when I run:

declare @ TimeVal varchar(16); -- Added space between @ and TimeVal to get code to post

set @TimeVal = '00.13.00';

select @TimeVal, cast(replace(@TimeVal,'.',':') as time)

declare @ TimeVal varchar(16);...