I created a DTS package (moves data from ACCESS to SQL Server 7 tables)
on the server. When I execute the package from Enterprise Manager on the server,it runs fine. When I schedule it to run ever...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10738441.html
HI,
I have a number of DTS packages each updating a table. I want to put them in a transaction. Is it possible?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_12029359.html
I have a DTS package on Server A. I need to install it on Server B. How can I get it from one server to another if there is not a connection between the two servers (ie Package Save As is not an ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20116319.html
Hi,
I need some scripts to automatically add "items" to a database.
I'm using osql to add tables, stored procedures, ...
I'm looking for a command line utility that allows me to add a DTS pa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20133820.html
Hi!
I am running Sql Server 200 on W2k and I need a DTS package to run automatically two times a day. My DTS first erases all my tables and then (with a "on success" workflow) it loads the new i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20606050.html
I have a situation where a selection of files arrive by FTP, I need to run a DTS package to copy these files from one location to another unless the file already exists in EITHER the destination di...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20707000.html
Hi,
I want to access MDB file from my SQL DTS Package. But the Ms-Access MDB is located in
my webserver. SQL Server is located in another webserver. I need to move the Ms-Access
tables to ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20728731.html
I have a sql2k database which has a dts package. This is called from a sproc (which also executes some sql) and needs to be run every two days or so - manually (through an asp.net front end).
Ev...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20912581.html
Hi,
I have one DTS package. Which does 4 things.
1. Connection to local server with user/password
2. Delete rows from table X
3. Connecting to remote server with remoteuser/remotepassword
4....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20969744.html
Hi,
I need to run a simple DTS package from the asp.net page. i have button on the webform i need to run the dts package for that button click event.
I was trying to find examples on the intern...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20971402.html
