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

system243trd (10/21/2013)

---

I thought I explained it fine, but here goes again

I am trying to run an SSIS package an install it on a file system - here are the steps...

system243trd (10/21/2013)

---

I have created an SSIS package using BIDS. The package does not have any connections to a database.

I have built the package to the bin folder.

When I navigate...

It sounds like you are very close to success - well done on getting so far.

Are you able to determine at exactly which point in the dataflow that the padding...

That was a good day. You should see me with a hangover.

There are, probably, millions of examples of how...

blasto_max (10/20/2013)

---

I want to get all the rows in one column of a record set and concatenate them into a string. I want to do it using C#. How do...

No.

dan-572483 (10/18/2013)

---

Koen Verbeeck (10/18/2013)

---

The package...