am trying to design SSIS for ETL from access/excel sheets to SQL Server and will require transformation with script task in VB.
the SQL Database in question is on a Shared server and cant get SA permission on the virtual box.
the suggestion from the 3rd line support team is to create and design my package o my laptop with windows 10 and install Visual studio/ SSDT
ive always designed and tested SSIS packages on a server .
Is it possible to design, run and test SSIS on my laptop with Visual studio installed . My laptop has windows 10 . anyone done this before please?
the SQL Database in question is on a Shared server and cant get SA permission on the virtual box.
the suggestion from the 3rd line support team is to create and design my package o my laptop with windows 10 and install Visual studio/ SSDT
ive always designed and tested SSIS packages on a server .
Is it possible to design, run and test SSIS on my laptop with Visual studio installed . My laptop has windows 10 . anyone done this before please?