"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OrwxHZ$7FHA.2576@TK2MSFTNGP12.phx.gbl...
> Michael.
>
> Bit confused now then
>
> So you are not using the Copy Objects task? If that is the case and you
> are only using the Data Flow task then?
>
> If this is the case then in DTS you would have had to specify the DEFAULT
> on the column when you created the destination table right?
>
>
> Allan
>
>
> "Michael Tissington" <mtissington@newsgroups.nospam> wrote in message
> news:OKek$X#7FHA.1600@TK2MSFTNGP10.phx.gbl:
>
>> Allan,
>>
>> Not the wrond task - I can only use Copy objects if I have sysadmin.
>>
>> And besides in SQL 2000 this worked correctly!
>>
>> --
>> Michael Tissington
>> http://www.oaklodge.com
>> http://www.tabtag.com
>>
>> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
>> news:enTdI567FHA.1148@tk2msftngp13.phx.gbl...
>>
>> > Michael
>> >
>> > Wrong task. You should be using the Copy SQL Server Objects task.
>> >
>> > Allan
>> >
>> > "Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in
>> message
>> > news:N$Klvm07FHA.4000@TK2MSFTNGXA02.phx.gbl:
>> >
>>
>> >> Hi Michael,
>> >>
>> >> Would you please help me clarify "In SQL 2000 and dts packages this
>> was
>> >> not
>> >> a problem, defaults were copied"?
>> >>
>> >> I have made the test with SQL Server 2000 below
>> >>
>> >> 1. Create a new table in the SQL 2000
>> >> ------
>> >> create table test12
>> >> (
>> >> pid int,
>> >> idd int default 5
>> >> )
>> >> go
>> >> insert into test12(pid) values (1)
>> >> insert into test12 values (2,2)
>> >> insert into test12 values (3,4)
>> >> insert into test12(pid) values (5)
>> >> ------
>> >>
>> >> 2. Create a new Package in DTS, When generating a new Transform Data
>> >> Task,
>> >> it will be a prompt Dialog with the schema below for Destination
>> >> database
>> >> ------
>> >> CREATE TABLE [test12] (
>> >> [pid] int NULL,
>> >> [idd] int NULL )
>> >> ------
>> >>
>> >> You could see that in SQL 2000, it will also not generating the
>> database
>> >> with default value.
>> >>
>> >> 3. Execute the DTS package and all data will be tranformed swimmingly
>> to
>> >> the destination server.
>> >>
>> >>
>> >> Sincerely yours,
>> >>
>> >> Michael Cheng
>> >> Microsoft Online Partner Support
>> >>
>> >> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> >> that others may learn and benefit from your issue.
>> >> =====================================================
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>>
>> >
>

"Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in message
news:Fq$dNyL8FHA.3380@TK2MSFTNGXA02.phx.gbl...
> Hi Allan and Michael,
>
> Thanks for the update.
>
> Allan is right and I used wrong task at first.
>
> Michael, I have reproduce it on my side as your have described. It looks
> like an issue in the SQL Server 2005 Integration Services. I have submit
> this to development team via internal resouces. You are also encouraged to
> submit this via the FeedBack link below
>
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
>
> If there is any update for this issue, I will post here.
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>