Click here to Skip to main content
15,561,685 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an SSIS solution where depending on a parameter, it launches the extraction of different databases, each in a different file, and the name must contain the date of the extraction so we can't hard code the name in the Destination wizard, I must use a variable where I concatenate the date to a file name, and I have to use that variable as the file name.

What I have tried:

I crateated this variable : "C:\\Users\\Nemos\\Desktop\\H\\T\\INC\\Contrats_INC" +"_" + (DT_WSTR, 06) @[User::VMois_EXEC] +"_VD" +".csv"
In the propreties of my file i added an expression as a connection string and i droped my varaiable.
Still won't work
Posted
Updated 15-Nov-21 4:46am

1 solution

 
Share this answer
 
Comments
houssem eddine ayari 15-Nov-21 10:15am    
I did the same thing but the problem continues. Error: "Unable to open data file 'C: \ Users \ Nemos \ Desktop \ H\ T\ Contrats_INC_202110_VD.csv"."
If the files doesnt exist i added delay validation and still not working
phil.o 15-Nov-21 10:35am    
You could try to put the file in a folder with no restrictions for anyone, and test whether it is an access-rights issue.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900