So you were able to create the tables (please create them in their own database, and not in any of the system databases (master, msdb, tempdb, model))

Maybe using the GUI...

great solution Bob.

Nice application of outer apply. Still have to get used to that feature 😎

start with:

Select ...

from information_schema.tables

where table_name like '%yourcryteria%'

order by table_name

Just like the others, I would suggest to first concentrate on TSQL, Management studio and sqlserver organisation (detailed if needed), then you'll get to sqlcmd for deployment facilities,...

If this is a single shot action (migration ?) it may be best to use Microsofts migration assistant for Oracle. It can be downloaded free from here :

http://www.microsoft.com/sql/migration/

This may...

barryocteau (4/11/2009)

---

I have a DotNetNuke database that functions well enough but when in SSMS the Tables item doesn't expand to show tables, the same with System Tables. Other databases display...

bambang (4/11/2009)

---

Dear Bro ALZDBA,

Thanx for your suggestion, but it's not work yet.

The query result would be like this :

PrimaryKey1 PrimaryKey2 TitleOrder Title TitleDescription

1 1 0 Movies A great movies

1...

In many cases, problems start with people creating every column nullable - except for the primary key column(s) - without popping the questing of for that specific column NULL is...

bambang (4/11/2009)

---

Dear bro and sis,

I have a problem to update data from table.

The Source table looks like this:

PrimaryKey1 PrimaryKey2 TitleOrder Title ...

- Post the xml schema and we may be able to get you on track

- maybe my recent post can help a little.

http://www.sqlservercentral.com/Forums/Topic678236-21-1.aspx

Do you have access to visual studio team edition for database admins ?

As long as it doesn't add Kg's ... :w00t::-D

Hey, maybe...

I tested it overhere and always got the correct results (x86 (std ed)and x64 (ee))

select LEFT(NULL,ABS(CAST(CHARINDEX('.',NULL) AS INT)-1))

select LEFT(NULL,ABS(CAST(CHARINDEX('.',NULL) AS BIGINT)-1))

select LEFT(NULL,ABS(CAST(ISNULL(CHARINDEX('.',NULL),NULL) AS INT)-1))

go 1000 -- executes the previous batch...

you may want to try it out by logging on to your server that launches the ssis package and using that service account (or proxy).

Then try to use the unc...

are you using the same ansi settings when executing on the different instances ?

What do you expect as a correct result ?