rocky_498 (10/24/2013)

---

Here is the Sample Data

ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID

DS,BP9744524,CARLSBAD,D,BR9307299,UNKNOWN

I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.

Please guide me or...

If this was your question, why did you start the thread with:

How do I...

blasto_max (10/24/2013)

---

Koen Verbeeck (10/24/2013)

---

Just curious: why do you use a script task as a destination? What is your destination?

Maybe there are easier alternatives.

As long as you don't use any blocking...

Some rough pseudo-code:

rowA = readRow;

rowB = readRow;

do

if (rowA.Type != "Test" || rowB.Type != "Test")

ignore

else

output rowA;

rowA =...

Even better (IMO) is to use something rare as your column delimiter (eg |).

Then you don't need the extra "s & save some disk space...

This can definitely be done using a Script Component. It should be asynchronous, because not every input row will have a corresponding output row.

I did not reply sooner because your...

What have you tried?

Rather than looking at the source data in Excel, can you please open it in Notepad++ or similar and then have a close look at the offending data?

From your screen...

scuby.me (10/22/2013)

---

i have a ssis package where i need to import data from excel to sql table which does it job perfectly. and also i have execute sql task which...

Collate is relevant for strings, not numerics. You need to remove it from the bigint.

aaron.reese (10/22/2013)

---

Guys,

I have a flat file which gets written in three parts (generic header, specific lines, generic footer with a rowcount from the lines). We experienced a 1:1000000 error...

dan-572483 (10/21/2013)

---

I swtiched from the Jet provider to the ACE Access 10.0 provider, but I'm havng the same result: The data from the text source file successully imports, but...

Great! Thanks for posting back.

In your flat file connection manager, which 'Format' are you using?

I would suggest trying out 'Delimited' with 'None' as your Text qualifier and {CR}{LF} as your column delimiter.

miles_lesperance (10/21/2013)

---

I copied the data from the Data Viewer, between the OLE DB Source, and the Flat File Destination, and, using ConText, I am able to determine that the column...