That is a fixed-width file and you should import it as such - not as a CSV file.

Can you explain what you're doing? Maybe there's a better approach.

No problem -...

Sounds like a plan.

If you export from Excel to CSV after performing this reformatting, is the formatting of the field the same as was originally output?

If not, what happens if...

Baskar B.V (8/11/2010)

---

have done data population dynamic using DTS... We pulled the column info using...

Rich-403221 (8/11/2010)

---

Sure you can. Configure the DataSource for where the data is coming from, and then configure the destination, setting the DataAccessMode to be TableNameOrViewNameVariable. Create the variable at the...

But if the table doesn't exist at design time, you can't create the dataflow.

If you want to put data in them too, you might find this a challenge.

stricknyn (8/11/2010)

---

Phil Parkin (8/10/2010)

---

Here[/url] is a nice article, though probably not applicable to your scenario. Worth a read anyway.

Code reuse in SSIS is not as easy as it could be....

Why are you writing in code? This is not a crossword forum.

If you want help about a specific topic, please ask a question.

Baskar B.V (8/10/2010)

---

MostInterestingMan (8/10/2010)

---

Hello,

I have a date column with data type DT_DBTIMESTAMP that I am exporting to .csv. In the Flat Connection Manager the data type is correct and I...

Excel is helpfully (:crazy:) doing the conversion for you. Try opening it in Notepad and you'll see that it's just the same as the .txt.

Not that I know...

What are you using to view the CSV?

Here[/url] is a nice article, though probably not applicable to your scenario. Worth a read anyway.

Code reuse in SSIS is not as easy as it could be. To do what...