That's hashed, encrypted, or proprietary... and rather wild. FLOAT?!

Any chance you can share the name of the software?

Anyone with some SSIS/flatfile export experience help me out at this thread, please?

http://www.sqlservercentral.com/Forums/Topic1030096-148-1.aspx

sjimmo and I have been going back and forth about workarounds but we're apparently missing the main question,...

Ah, that helped cure my confusion. I apparently just can't read. I was, for some reason, trying to get multiple events out of the structure. :hehe:

What you've...

I'm sorry, but apparently I'm not being clear enough here. There is no flatfile before SSIS uses it. SSIS creates it.

I...

I goofed off with this but the data layout seems a little strange to me, it may just be some internal assumptions I'm making about the data.

Any chance you can...

sjimmo (12/3/2010)

---

Craig, This is a common issue when dealing with files from Unix/OS2 systems. The end of record mark for those systems is a LF and not CR/LF as a...

I found *a* solution, but it's a bad one from my perspective. I've created a computed column with "/r/n" in the expression and linked that into the final result...

If I understood this correctly, you're basically just starting to use SSIS at all, and you need a beginner's guide.

Create some sources at the bottom, connecting to the different database....

Sorry, got distracted:

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

JOIN sysindexes AS i ON i.id = t.object_id

WHERE c.name LIKE '%n%'

AND...

join to sysindexes on indexID IN ( 0, 1) and check the row column.

There's no quick and clean way.

One method is to do a select into a temp table for just the sorted columns with an IDENTITY() field, to find your...

Without...

nzrdb6 (12/2/2010)

---

Help! I've reached the limits of my knowledge as a humble DBA. Here's the problem -

there is a firewall between London and Berlin. What must I ask my...

Phil Parkin (12/2/2010)

---

Craig Farrell (12/2/2010)

---

LutzM (12/2/2010)

---

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after...

Tara-1044200 (12/2/2010)

---

I also see this message in the error logs after 1 sec of the above message

SQL Server is terminating in response to a 'stop' request from Service Control...