Nice script. Mind posting this to our "scripts" section?

Steve Jones

steve@dkranch.net

Well, I had a short chat session with nasir afridi and here is some followup:

The DDL for the table:

if exists (select * from sysobjects where id = object_id(N'[dbo].[ProductOwnerInfo]') and OBJECTPROPERTY(id,...

Sorry, not really an Oracle guy. I'd start with Oracle, my company (www.iqdestination.com) also has some lower cost e-Learning options. Some of the other guys here have Oracle systems, maybe...

Please let us know if this works.

Steve Jones

steve@dkranch.net

http://www.sqldts.com/article.asp?nav=1,6,208,7

Steve Jones

steve@dkranch.net

http://forum.snitz.com/

Steve Jones

steve@dkranch.net

don't see a way to access this. To even get a reference to the package, you must have the name to load it. Can you not just set a global...

what a knucklehead. I'd say grasshopper still needs to practice grabbing the stone from your hand

When I go on vacation I dread coming back to fix...

You're welcome. Keep coming back and spread the word to your friends.

Steve Jones

steve@dkranch.net

Check this out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp

Bug:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q300385

This also might help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_cdo_idatasource_saveto.asp

Steve Jones

steve@dkranch.net

You can also do something like this:

http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp

Steve Jones

steve@dkranch.net

Let us know if that helps. Also, what Service pack is this? (SQL and NT)

Steve Jones

steve@dkranch.net

I think Nigel is on the right track. You likely have some corruption in a system table, but it is probably bad data. If you can try some different things...

I've done this quite a bit. There should not be a mapping for the field on the transformations tab.

Also, a PK in SQL Server deos not necessarily mean an auto-generated...

Not that I know of. I think you would have to remove all references to this before you can change it.

Alternatively, you can create a new datatype and move all...