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 ?

Has the account that launches the ssis package been granted read authority on your UNC path / file ?

(service account of sqlagent or proxy account of the sql jobstep that...

It is as useful as putting a fence around your house.

Anyone wanting to walk on your territory will have to do a bit more effort to get there.

So, maybe they'll...

Basically, with a migration scenario, you install a fresh sqlserver (not necessarily on a new box) of the edition you want to migrate to, and then you copy the databases,...

We install SSMS + BOL on every sqlserver server.

(BIDev studio will only get installed at request.)

Why do we install SSMS locally on the server ?

Because we are only allowed to...

I advise to use Gerts solution on SMTP mail to avoid all the hassle with the mail client.

Have a look at http://www.sqldev.net.

It will off course need an extra step to...

HTH

Just make sure you test it (so you get to see the lovely pictures as desired) 😉