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

Expanding a little on this, you could use linked Sequence containers to get the exact concurrency and processing order you require.

Brandie Tarvin (8/10/2010)

---

Hmm. I didn't think about trying Object. I'll give that a shot.

But I'm not mistaken, am I, that 0 as a value should work fine in a Double...

Very weird. Perhaps you could debug the package by changing the variable's type to Object to get over this error and then inspecting its contents...

Thanks for posting back & I'm glad to have helped.

Phil

No problem. Add a Script Task, open the properties and Edit Script. You'll find a load of template code already in there. Replace the bit from

Sub Main

to

End Sub

with...

lduvall (8/9/2010)

---

I've determined that all I need to do to make this work is to open up the file and add a comma to the end of the header record....

Bizarre answer - this is not a Boolean logic test. My question asked you to identify one or the other.

If you meant that you are using SQL Server as...

How do you mean: 'using SSIS as your back-end'?

Is your VS app somehow calling an SSIS package, or did you mean that you were using SQL Server as your back-end?