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 |
|
vavs
Starting Member
24 Posts |
 Posted - 2012-01-10 : 10:37:37
|
| I am new to the forum and in the process of moving from SQL 2000 (please stop laughing) to SQL 2008. My understanding is that the DTS that I have can be made to work but the process is difficult at best. I only have about a dozen or so DTS that I run on a daily basis. They are all very similar and basically do the same thing with different files. Here is the scenario. I have a UNIX box (now virtualized) that contains the tables that I need. I run the DTS script that runs the following:*SET ROOTDIR="\\server\JOBS\AllianceDW"@echo ============================ >>%ROOTDIR%\logs\dl-FRINFM.TXT@echo Export and Downloading started >>%ROOTDIR%\logs\dl-FRINFM.TXT@time /t >>%ROOTDIR%\logs\dl-FRINFM.TXT@date /t >>%ROOTDIR%\logs\dl-FRINFM.TXT@echo ---------------------------- >>%ROOTDIR%\logs\dl-FRINFM.TXTc:\enlink32-sql\elink FRINFMftp -s:%ROOTDIR%\FTPScripts\DL-FRINFM.FTP 10.78.0.1 >>%ROOTDIR%\logs\dl-FRINFM.TXT@echo ---------------------------- >>%ROOTDIR%\logs\dl-FRINFM.TXT@echo Export and Downloading Done >>%ROOTDIR%\logs\dl-FRINFM.TXT@time /t >>%ROOTDIR%\logs\dl-FRINFM.TXT@date /t >>%ROOTDIR%\logs\dl-FRINFM.TXT@echo ============================ >>%ROOTDIR%\logs\dl-FRINFM.TXTMOVE FRINFM.TXT %ROOTDIR%\IMPORTSMOVE FRINFM2.TXT %ROOTDIR%\IMPORTS\*The enlink reference is a telnet session that runs on the server and connects to the UNIX box. If I can get this to run I will use the SSIS on 2008 and simply write the new scripts to run in jobs every morning. If this is not possible, I am open to suggestions on how to call the program and run the underlying scripts on UNIX from SQL 2008. I have to guess that this is going to be possible but I am so new to 2008 that I would rather get the information up front.Thank in advance for any help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-10 : 10:41:45
|
| you can achieve the same requirement by calling bat file from execute process task in SSIS. If you opt for directly doing it from t-sql, then you need to use xp_cmdshell to call the bat file and execute the above code------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
DTS conversion