I am writing an SSIS package. I am fairly new to SSIS (2005 if that makes a difference). I have taken a course but they have never addressed this particular situation.
I have to:
1 - Create an Excel spreadsheet from a stored procedure
2 - Rename it to a date stamped file name
3 - Copy it to an FTP server
I have been able to accomplish #1 with the help of the Import/Export wizard, so now I have an Excel sheet with a fixed name. I can't get # 2 to work. I think I want to use a File System task to rename the file to the date stamped version and capture the name of the file in a variable so that I can use it in the FTP Task, but I can't figure out how to do this (or even if my approach is correct).
asked May 05 '10 at 03:16 PM in Default
Thanks. I got everything working. Then the company that we are sending the file to informed me they wanted a text file, not an .xls file.
turned out to be relatively simple to do. I just changed the dataflow task to have a Flat File Destination instead of an excel Destination. I had to jump through a few hoops but I got it done.
My problem is dates in the source. I am writing the data I need to a source table with the dates defined as [surveyend_date] nvarchar NULL.
In my SQL table they are as I want, e.g. 053010, however in my .csv destination they show up as 53010. Is there any way I can get them the right way in the .csv file?
answered May 14 '10 at 01:01 PM
This should be able to help you.
Let me know if you run into any problems.