SSIS 2008: Write to a text file.
I am troubleshooting Data Flow in an SSIS package. I want to write to a text file. I am taking the package in steps. As an example:
1) Connection Manager
2) If successful - write passed to text file else write error to text file
Then test additional steps:
1) Connection Manager
2) Export Data to Excel
3) If successful - write passed to text file else write error to text file
Thanks
1) Connection Manager
2) If successful - write passed to text file else write error to text file
Then test additional steps:
1) Connection Manager
2) Export Data to Excel
3) If successful - write passed to text file else write error to text file
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i did just try to create a script and connect a task i receive the following error:
"The destination component does not have any availalbe inputs for use in creating a path"
"The destination component does not have any availalbe inputs for use in creating a path"
The type of script you need to create (source, destination, or transformation) depends on where in the data flow it is sitting. Perhaps I misled you in having you create a script transformation, as that would be most appropriate if you already had some data coming in to the script. If your script is first, try creating a source transformation instead.
ASKER
my script is not first. Its doing a database connection then I want to write to the text file. I am writing to troubleshoot so I can find the error.
ASKER
I used the dataviewer which provided me with what i needed.
ASKER
Data Viewer is the solution to the problem.
ASKER