Export to txt file

Last Post 11 Dec 2007 11:38 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
11 Dec 2007 10:20 AM
i have simple SSIS taht exports a few view into bar delimited txt file

So i have a connection set up to my db and connection set up to a txt file it works great.

The problem is a new requirement that i need to have timestamp in my output text file name?

Is there a easy was in ssis to have new file created everytime it runs with timestamp as part of file name?


Thanks
dbandee
New Member
New Member

--
11 Dec 2007 11:38 AM
ok
i can use bcp work fine, i can generate my file name string

but bcp does not export column names?

any ideas on how to acomplish this?

thanks
You are not authorized to post a reply.

Acceptable Use Policy