ERROR:While trying to generate pipe delimted file from the query

• komal145

  SSCrazy Eights

  Points: 9918

  More actions

  July 20, 2016 at 2:03 pm

  #315429

  I wrote simple query and wanted to save that result as a pipedelimted file .

  ERROR:

  The file name property is not valid. The file name is a device or contains invalid characters.

  my variablesname and variable value:

  @[User:filename]=@[User::WorkingDirectory]+"\\"+ "Daily_Tracking_"+ @[User::vDate] +".txt"

  @[User::WorkingDirectory]="\\\\"+ @[$Project::OLE_Stage_ServerName] +"\\Temp\\bb\\Aaa"

  @[User::vDate]=

  (DT_STR,4,1252) datepart("yyyy", getdate())

  + (DT_STR,2,1252) datepart("mm", getdate())

  + (DT_STR,2,1252) datepart("dd", getdate())

  +" "

  +Right("0" + (DT_STR,2,1252) DatePart("hh",getdate()),2) +":"

  + Right("0" + (DT_STR,2,1252) DatePart("mi",getdate()),2) +":"

  + Right("0" + (DT_STR,4,1252) DatePart("ss",getdate()),2)

  I use @[User:filename] variable in connectionstring property of "flatfiledestination" transformation to generate filename for generating file with the dtaetimestamp append to that .txt file

  I get the filename error? Please help me , unable to find what is wrong ?

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  July 20, 2016 at 2:40 pm

  #1891173

  looks like you have colons (for the time separator) in your filename, not sure windows likes those...

  Steve.