Chrissy321 (5/2/2011)

---

Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not...

You'll need a hex editor to see the 'invisible' characters.

Isn't that the same product as suggested by the previous poster?

smoo (5/2/2011)

---

We are looking to use SSIS for scheduling and we also need to log the data retrieved on a different server.

With that in mind, we're using an OLE DB...

Why do you need SSIS if you can do everything you need in T-SQL?

Are you sure? How did you check? What do you want to do with the bad data?

A couple of ideas spring to mind:

1) Do not use Select *

2) Put a dummy Select near the top of your routine to try and trick SSIS into thinking it...

I think you need to put something between the BEGIN and END - not just a comment.

jpSQLDude (4/26/2011)

---

This is embarrassing to ask, but I just can't find a clear answer. First, this article seems pretty clear in explaining Decimal vs Binary, and mebibyte (binary) vs. megabyte...

This works:

DECLARE @CRTEXT VARCHAR(50)

SET @CRTEXT = 'Text ' + CHAR(13) + CHAR(10) + 'more text'

SELECT @CRTEXT, REPLACE(@CRTEXT, CHAR(13)...

One of my larger concerns here is the prioritization of the suborder within an ID. Unless that's pre-built into the file, this becomes a painful endeavour of conditional logic, and...

The first thing I'd do is use a hex editor to assure myself that I know exactly what the characters are which need to be replaced.

Then use REPLACE as part...

Thanks Craig.

I was basing my recommendation on this article which, now that I look at it, is not quite what is required here.

The sample code in the article creates 3...

LutzM (4/23/2011)

---

@Phil: the way I read it is that the OP needs Excel to add the column names manually and (guessing starts here) will import it into SQL Server based...

JStevenson1 (4/22/2011)

---

I receive semi colon delimited txt file and the column placements/position are always same. Currently, I am having to import it to excel and add column header to each....