balajii78 (4/7/2008)

---

hi all,

im a software engineer from india.Can any1 suggest me a learning centre/computer institute in chennai,India for learning SSNS and SSIS?id like 2 go for a course in these...

Andy Leonard wrote an article on how to do incremental load. In it is a nice method for doing the updates in a set-based (putting the updates in the...

I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find the view in MASTER. Yes...

Or - execute the DTS package from DTSRUN or DTSRUNUI on the local machine. By running from a local user and under the correct security context, you'd have access...

madhu.arda (4/4/2008)

---

actually Iam using a OPENQUERY, which calls the server db2,in this case iam choosing sql command not table or view so i did not the option for batch in...

GSquared (4/7/2008)

---

I checked over the weekend, and I don't currently have SSRS installed on my Vista machine (it's at home). If I remember correctly, even if you install IIS...

rbarryyoung (4/6/2008)

---

Heh, you should meet my Uncle. He taught me to program when I was 13, but he learned computers as an electronics instructor for the Army Air Force...

Keep in mind that SSIS tracks the column size in several places. Changes the destination's size is nice, but you also need to do it in the "input" properties...

Six correlated sub-queries is going to make anything squeal in pain....Wow.

How about this as a rewrite?

Select Distinct Country As Country, IsNull(ProductCode,'') As LocalProductCode, isNull(PackCode,'') As LocalPackCode

into #t1 From ILSRep..PL_Sales...

:

Jeff Moden (4/6/2008)

---

Gates should give everyone who bought Vista a free copy of XP to install whilst we all wait for a decent version of Windows (7?) to come out...

Pile on the love fest!

Very nice work and congrats to both!~

Jack Corbett (4/5/2008)

---

Adam Haines (4/4/2008)

---

If the table has an identity field with seed, why are you trying to insert a value for it? I do not see why you...

It would be a whole lot easier to help you if you would give us some details to go on. Such as - what does the table look...

Please don't double-post. Conversation continues over here:

http://www.sqlservercentral.com/Forums/Topic480369-8-1.aspx

Agree with Jack.

SQLMail is on its way out (I don't think it will exist in 2008). It requires an "extended MAPI client", which coincidentally equates to an...