Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
p_gauri77
Starting Member
2 Posts |
 Posted - 2010-02-26 : 15:35:51
|
| Hi,I am a newbie in SSIS and creating one. The requirement is that a new text file should get created based on the input data from a table. I added a Flat file destination to the data flow. But can't assign a flat file connection to it since the connection requires a file to exist. If I enter a file name that does not exist in the connection manager dialog box, it can't get the column names and so doesn't let me proceed. Any ideas?Thanks in advance,Gauri |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-02-26 : 15:53:08
|
| Here's a step by step explanationhttp://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/ |
 |
|
|
p_gauri77
Starting Member
2 Posts |
Posted - 2010-03-03 : 15:12:05
|
| Thanks for the link. Worked perfect. |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-03-03 : 15:15:42
|
You're welcome.  |
|
|
|
|
|
|
Create new flat file using SSIS