June 11, 2014 at 10:07 am
Hi
I am using SQL Server 2008 r2 and I have to achieve blow result in through SSIS, Can any one give me step to achieve below result.
1. I have date Field: AOBdate in table:XYZ
2. I have Process.cmd file which copy data like below
copy C:\Development\CAD.XLS C:\Development\report\%1CAD.XLS
now I want to open above Process.cmd file and replace %1 with AOBdate from table XYZ and run Process.cmd file. After completing above process I want see my old Process.cmd file with %1 like (copy C:\Development\CAD.XLS C:\Development\report\%1CAD.XLS) for next day use.
Thanks In Advance.
Venkat
June 12, 2014 at 5:17 am
You want to edit .bat file from SSIS before and after some process?
June 12, 2014 at 7:47 am
Basically I need a need a script component which gets date from Table XYZ and pass a input parameter dynamically to execute process task (execute process task is going to run .cmd file)
I need steps and script to create script component (I am not good in scripting) .
June 12, 2014 at 8:11 am
venkat5677 (6/12/2014)
I need steps and script to create script component (I am not good in scripting) .
Did you consider hiring a consultant? Remember the people on these forums are unpaid volunteers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply