dawnbrown243 (5/7/2013)

---

OCR means Optical character recognition, it is the mechanical or electronic conversion of scanned images of handwritten, typewritten or printed text into machine-encoded text. Some PDFs are scans, so...

visu.cts2012 (5/8/2013)

---

I'm working on some real time project. There is an already existing DataBase. In that DB, i need to change particular column DataType. Can we change datatype of column...

dg227 (5/7/2013)

---

Without PS or a script component, you can treat the data records in the given file as a single column text field. In the data flow, start with...

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the doubt I like to code extracts...

SteveEClarke (5/7/2013)

---

Totally amazing when you read a piece of code so many times and blind by your own perfections.

Have a sandwich .... have a drink .... come back ....

Only to...

OK - forgot about that. But at least you can change the date bit. The error message suggests that that is where your problem is occurring.

That's what my code does.

Why not avoid the datatype conversions completely?

declare @Today date

declare @NowTime time

select @Today = getdate()

,@NowTime = getdate()

select @Today

...

manibad (5/6/2013)

---

sgmunson (5/6/2013)

---

I'm at the point of making an assumption about what the poster meant by their most recent post. Given the technique of concatenating a series of...

pmcquirk 96901 (5/6/2013)

---

Basically I am recieveing multiple flat files of two different file layouts, the file names do not give a clue to the layout, howevet the files (pipe delimited...

OK, I see what you are getting at, thanks. I still cannot see why that causes a formatting problem when outputting though.

Learner093 (5/3/2013)

---

I have a set of record types saying TH as Header and T1a, T1b, T1c, T1d, T1e, T2a, T2b, T2c, T2d, T2e as other type of records. TH table...

sgmunson (5/6/2013)

---

The number of fields that can be included in the query's use of ISNULL and NULLIF is not limited to two. You can just keep concatenating an ISNULL...

Steve Shurts (5/6/2013)

---

Very interesting... I just had to play and it was fun. However, I can't think of any clever usage for it, yet. But give me...

Hi Wayne.

Nice article, thank you.

Can you explain what you mean by: "...you can specify what the server is change all the variables at one place simply" please - it...