cassaudi.blogg.se

Public partial class ScriptMain : .ScriptTask.VSTARTScriptObjectModelBase The DBA team is working on it however i was wondering if i can convert my picked up latest excel file into a CSV ? Because the csv automation on Agent runs fine.īelow is the code i have currently in Script task, Can someone please help me with this? region Namespaces

I have a script task which will basically pick up the latest file from the folder and then pass it to the "Data Flow Task" where it will be loaded into the SQL Server, this process runs fine on visual studio however it fails on SQL agent because of the missing drivers.