• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 586
  • Last Modified:

dynamic flat file name in SSIS

Creating a SSIS package. I need to write data in a flat file form one of my tables. So I created a flat file connection manager which has the file name and all the columns in the file. I added a data flow task to my package. On the data flow tab I added OLE DB Source connecting to a flat file destination.

I want to name my flat file same as the project name +".txt". The project name is stored in a user variable, but I don't see where I can specify that file naming convention. Please advice.

Thanks,
0
patd1
Asked:
patd1
1 Solution
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Hi Add an expression for the connection string   over the "flat file connection manager"

confusing? see attached... e
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now