Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2008 - why no "create file" in File System Task ? Expand / Collapse
Author
Message
Posted Friday, October 4, 2013 5:42 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
I did not see that option. Why don't they have it there ?
Post #1501798
Posted Tuesday, October 8, 2013 6:28 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
What are you ultimately trying to accomplish?
Post #1502578
Posted Tuesday, October 8, 2013 8:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 2,819, Visits: 2,563
If you just want to create a blank file, you are right, there is no way to do this. However, the File System Task can create a new file using copy/move and a dynamically named target by using a variable for the target name. You can also create a new file as a destination in a data flow task, again by using dynamic / variable sourced file paths and names.
Post #1502629
Posted Tuesday, October 8, 2013 9:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
Tee Time (10/8/2013)
What are you ultimately trying to accomplish?


Just making a simple package to test parent child relationships and real world package deployment. I replaced it with create directory instead.
I wonder why there is no create file.
Post #1502688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse