sql server dts: SQL Server 2000 Import and Export -- sql server dts

SQL Server 2000 Import and Export

Joe K.
6/18/2007 3:45:00 PM

sql server dts:

I am using the SQL Server 2000 Import and Export program to copy data from
SQL Server tables to Oracle tables. I have the Import and Export program to
create the Oracle tables. The table names in SQL Server are all lowercase
how can I have the program create the table names in uppercase?

Please help me with this issue.

Re: SQL Server 2000 Import and Export

Allan Mitchell
6/19/2007 4:46:53 AM

Hello Joe,

Not sure that you can with the wizard. The best you can do would be to save
the package and then write a little script that went through each ExecuteSQL
task that creates a table and change the

CREATE TABLE dbo.lowercase(

into

CREATE TABLE dbo.LOWERCASE

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]