Hello,

I have a created a DTS package where I am transporting data from a
Sybase system to a SQL Server system. There are approximately 272
tables which need to be transported. I know how, through the UI, to
specify on a per connection or table setting the 'identity_insert' ON or
setting the default batch size to use [other than 0].

I am curious in what database the DTS package existing and how I can,
through SQL, go in update values so I do not have to do a lot of menial
tasks? Also how does this apply to SSIS in SQL Server 2005?

Thanks,

Shahryar

--
Shahryar G. Hashemi | Sr. DBA Consultant

InfoSpace, Inc.
601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA
Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150
shashem (AT) infospace (DOT) com | www.infospaceinc.com

This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s); any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. Thank you.