KoldCoffee (4/9/2014)

---

No Phil, that is not correct. You wrote to go to Advanced Editor of Flat File Source. But you didn't say to go to the Connection Manager...

As long as your data volumes are low and it works ...

But otherwise you should consider doing ALL sorting at source and then just setting the IsSorted property preceding...

KoldCoffee (4/9/2014)

---

I thought I'd share what solved this issue.

In the Flat File Connection Manager Editor (r-click and select Edit on the Connection Manager itself, not the Flat File Source Data...

Then do the entire source selection in T-SQL.

What are the data sources?

The advanced editor does not 'do sorting' - for that you need a SORT transformation. And these are slow - better to sort at source if...

You mean while the computer is powered down? As far as I know, pretty much nothing at...

a4apple (4/8/2014)

---

If the format keeps changing you can try using a Script task as Destination and you need to use a significant amount of code, I tried once.. I will...

Don't like the cursor. Can you run something like this?

SELECT o.name,

ddps.row_count

FROM sys.indexes AS i

INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID

INNER JOIN...

Resender (4/7/2014)

---

Ok I got the following issue:

SSIS to import flat files,everything went fine for months,now suddenly errors.

At first the errors indicated an error in the file (the provider of the...

naresh0407 (4/5/2014)

---

Hi All,

I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is...

Please read this and then post back with any specific questions you may have.

Lempster (4/4/2014)

---

Phil Parkin (4/4/2014)

---

Lempster (4/4/2014)

---

You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address...

Lempster (4/4/2014)

---

You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are...

Eric Mamet (4/4/2014)

---

I am indeed using SQL Server Developer edition 64 bits and I do get through once I have created a 32 bits alias.

I did not realise that...

Eric Mamet (4/4/2014)

---

Phil,

One more question if I may...

I can get this Alias to work when I connect through ODBC (like through MS Access or an ODBC connection through an...