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....

Actually, I think there is quite a nice way for SSIS to handle this - using an asynchronous...

Same as what?

To whom are you directing...

Neat.

And there was me trying to find the second occurrence of "\" and SELECT LEFT to that position, dealing with NULLs etc along the way. Not pretty.

bhavika.chauhan (4/20/2011)

---

Hi,

Every time i run my package , i create dome folders dynamically using FST . But i want to maintain a version for it . How can i create...

Who's this Keon then? 🙂