SSIS 2012 save to file with dynamic name

pvsbandi
pvsbandi used Ask the Experts™
on
Hi All,

   I'm new to SSIS.
    I have an urgent requirement to do the following:
a) I have a table TBL_FILENAME, which has a coulmn called "CName". This name changes every day.
b) I have another SQL query, which produces an output containing 10 fields.
c)  My requirement is to export the output of the SQL query mentioned in step b)
     into a pipe delimited file, where the name of the file should be "CName" mentioned in step a)
d) Also, the pipe delimited file produced in step c) should have the "CName" before the headers inside the file.

Can someone kindly help me with a sample package to achieve the same?
Thanks much in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Developer and Administrator
Commented:
This would be too long to describe.
Please request a Live Help or create a GIG.
Or send me your dtsx file in a private message.

Author

Commented:
Thanks! I have sent you a message

Author

Commented:
Thank you! Your msg worked.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial