Viewing 15 posts - 661 through 675 (of 1,118 total)
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...
July 31, 2009 at 2:05 pm
The first step is to determine what type of remote server you have.
Give it a try and let us know how it goes.
July 31, 2009 at 1:07 pm
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,...
July 31, 2009 at 10:51 am
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...
July 31, 2009 at 10:27 am
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...
July 31, 2009 at 10:15 am
If you post the complete package you are using, that would be the easiest.
July 31, 2009 at 9:51 am
Can you show what is the flat file configuration you have used for your flat file destination?
July 31, 2009 at 9:29 am
SQLSlammer (7/31/2009)
I am trying to export data to .csv from a sql server 2005 sp3 table using SSIS. This export normally occurs using a...
July 31, 2009 at 7:58 am
Lonnie Johnson (7/31/2009)
Oh, so I cannot use the FTP task to download a file from a website like I could if I were using CuteFTP or something?
Hmm.. Are you able...
July 31, 2009 at 7:54 am
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...
July 31, 2009 at 6:28 am
But this issue is different than your original question. Why not create another question in the forum and stay on topic?
July 31, 2009 at 5:39 am
SQLSlammer (7/31/2009)
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...
July 31, 2009 at 5:20 am
Alan Spillert (7/30/2009)
July 31, 2009 at 5:15 am
I would recommend that you reinstall your SSIS client. There is something wrong going on.
July 31, 2009 at 5:13 am
Joshi (7/30/2009)
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...
July 31, 2009 at 5:11 am
Viewing 15 posts - 661 through 675 (of 1,118 total)