I am not sure how to do this but I think it should be possible if using a bit of VBS code inside the script.
What I do now is this.
I have a DTS package (SQL 2k) that imports a CSV and an excel spreadsheet into tables and then I have a SQL script that does a join and select distinct to provide me a list of users and their default printers across our servers.
What I would like to do is eliminate the need for the DTS package and just use the script.
Any ideas?
Thanks
John Fuhrman
Titan Global Services
What I do now is this.
I have a DTS package (SQL 2k) that imports a CSV and an excel spreadsheet into tables and then I have a SQL script that does a join and select distinct to provide me a list of users and their default printers across our servers.
What I would like to do is eliminate the need for the DTS package and just use the script.
Any ideas?
Thanks
John Fuhrman
Titan Global Services