Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
In a Script Task I'd like to take that variable and assign just the date part ( i.e. without the time ) to a script variable.
SELECT GETDATE() as dtStartPackage
Question: How can I modify the above expression to only store the date?
Dim dtStartPackage As Date = CDate(Dts.Variables("dtStartPackage").Value)
Join the community of 500,000 technology professionals and ask your questions.