April 29, 2020 at 2:37 pm
Hi, Can someone show me (if its possible) how to create an ssis package to take the servername, tablename and todays date as parameters and export this table to a filename with todays date (formatted Filename_ddmmyyy.csv).
I've managed to get the dynamic filename but its hard coded to the table and i don't understand how to pass the parameters into the package when deployed
Darryl Wilson
darrylw99@hotmail.com
April 29, 2020 at 4:02 pm
https://social.technet.microsoft.com/Forums/azure/en-US/6c6e4fba-be40-4c53-ab8e-348ccd39c687/rename-file-using-file-system-task-editor?forum=sqlintegrationservices
This does answer a question, but not the one posed by the OP!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply