Have you used Process Monitor before? It is for tracing the operations with files and the registry. It will help you find what is going on, though it may take...

The first step is to determine what type of remote server you have.

Give it a try and let us know how it goes.

I have just created sample project from scratch. It selects from SQL Server table and it contains columns, which appear with type DT_DBTYPESTAMP. I have created a flat file destination,...

I agree it is rough sometimes. But again I cannot understand why CONVERT will not work? It should convert DATE/TIME column into a string. When you insert the data viewer...

Hmm.. It looks fine to me. I see you have tried to use CONVERT function in your select statement? This should work. Did you reset the flat file connection manager...

If you post the complete package you are using, that would be the easiest.

Can you show what is the flat file configuration you have used for your flat file destination?

SQLSlammer (7/31/2009)

---

Ok, lets deal with date problem first

I am trying to export data to .csv from a sql server 2005 sp3 table using SSIS. This export normally occurs using a...

Hmm.. Are you able...

I'm getting confused a bit. Are you talking about generation of CSV or reading from CSV? Can you start from the beginning by including more details step-by-step what you are...

But this issue is different than your original question. Why not create another question in the forum and stay on topic?

SQLSlammer (7/31/2009)

---

Hi there

I am exporting some data to .csv and when I look at the file in notepad, it shows the dates with additional characters at the end, I dont...

Alan Spillert (7/30/2009)

---

An Integration Services package copied four Oracle tables (version 10.2.0.3) and one flat file into five truncated SQL Server tables. The package then run a stored procedure...

I would recommend that you reinstall your SSIS client. There is something wrong going on.

Joshi (7/30/2009)

---

Hi, what is the simple way to rename the file in SSIS.

I got some idea, I think I need to use "File system task".

ex:

C:\hello.txt to c:\hello_2009-July-30.txt

I mean new file...