Skip to main content

Posts

Showing posts from February, 2009

SQL SERVER INTEGRATION SREVICE SSIS & FTP Service

Well after the long research i found the auto transfer the data from one system to other or one database to other with in very short time, well this research is based on the transfering of paradox data to the the online server via SSIS.
Well i did not found a pure solution for this issue but after a lenghtly research i found the ways that basically provide me the sucess regarding to this issue
Well the acctual project scope is transfering the paradox data from different local system to the online main website server
the scope seems to be very different and unique well we use SSIS technology for covering this thing

You need following steps to connect your local PC to the online server
1) SSIS (SQL SERVER INTEGRATION SERVICE) 2) SQL SERVER Job Agent
to be honest if the SSIS is not running propoerly then just reinstall the ssis with the propoer SQL custom instanace name because if start i have spend around a week to rectify the issue for running the SSIS but i found the misktake in the i…