Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ineedhelp
Starting Member
11 Posts |
 Posted - 2005-02-23 : 14:51:02
|
| HiI have to download data from AS400 to SQL server. For this purpose I have a DTS package on my local SQL Server. I need to send the package to other people to perform the same activity on their machines. They are in a different geographical location (this rules out my going there personally. And they are not so well-versed with SQL Server)1. Can I generate a script of DTS package and send it (Like we do with stored procedures)? 2. Can DTS package be executed from command prompt? Or from SQL Query Analyzer?3. What if they do not have destination database setup? Can I create a new destination database through DTS when specifying destination tablename?4. Any alternatives?ThanksThanks |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-23 : 16:54:56
|
| 1. Save the package as "structured storage file", you will have to edit the datasources after opening the file in sql server2. see dtsrun, from QA use exec xp_cmdshell 'dtsrun .... '3. they would have to have the appropriate odbc&software set up on their machines to connect to AS4004. You import all the data with your link to AS400, then use linked servers, bcp, dts or other techniques to transfer data between Your sql server and theirs.rockmoose |
 |
|
|
|
|
|
DTS package script