When I was consulting, the first thing I would ask for when I arrived at a new workplace was a copy of the coding standard. On the occasions when...

In my opinion, there is a continuum. The larger a project and its development team is, the more important consistency becomes. At one former position, it was my...

I own a bass guitar, and on occasion I use it to produce various sounds, but to say that I play it would require a serious re-definition of the verb....

Without more details, I don't know if I can be of help. In the SQL Agent job properties, have you verified that the owner is correct? If...

You could use a batch file to set standard naming prior to the actual call to SSIS:

import.bat:

rename xbouns.A%1 xbouns.bar

rename xbouns.B%1 xbouns.baz

rename xbouns.C%1 xbouns.yah

etc...

dtexec /f "C:\SSIS_Projects\loadfiles.dtsx

c:\>import 18

It's not terribly elegant, but...

I've not done any 1099 contracting, but I was a W2 contractor for almost 7 years with 3 different providers of various sizes. One of the things that I...

I tend to say Sequel, unless I am in a group of folks who all say ess-que-ell. I like the sound of squeal though. It definately brings the...

I have to agree. Medical data is definately its own kind of stress. That's what I've been dealing with...

I've had to to the gantlet style interview before and gotten the job, but I've never liked being hammered on by 5 people at once. I always assumed that...

Andrew Watson (2/26/2008)

---

We did something similar to this at work. What I found useful wasn't so much how it classified me (probably equivalent to an ISTJ - no surprise...

Jay H (2/19/2008)

---

Hey,

I am newbie to batch files. Any help would be appreciated.

I want to execute a dtsx package first and when complete execute an ant file.

First, I want to...

SQL King (2/5/2008)

---

Thanks for the support. But how is the comparison supposed to work? Meaning, there is no specific column given to me to compare the two day's data (yesterday,...

SQL King (2/5/2008)

---

I know it sounds easy, but believe me, it is something really crazy! I have this case where I have to bring data from 4 flat files to...

jsheldon (1/29/2008)

---

D smith,

questions:

If the values coming in from the flat file do not contain blanks at all, can I bypass the NULL reference? Also in Derived Column what do...

As a professional caveat, I'd advise against attaching files of live patient data to posts. You should redact the names or other personally identifiable information of any kind before...