i would appreciate someones guidance.... i receive daily downloads from some vendors...do processing via ssis on local pc which effects ~4 tables. i want to transfer these four tables to DASP sql tables on a daily basis. how can i programmatically transfer these ~4 tables. can i connect dasp to my local pc via a connection string? is there some automated ftp process where i can upload these tables from local pc and then use dasp scheduled task to import the data? any guidance would be appreciated
The only way I can think of at this point is to create a SQL script on your local database to script out these 4 tables you are telling us about. Since it is your own local SQL server you should be able to create a SQL job. Once you have these SQL scripts (should have an extension .sql) you should be able to create a batch file that runs a SQLCMD command that connects to our SQL server and run that SQL script against the SQL server. If you want it to automatically run, you should be able to run a task manager on your local computer to run that batch.
