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 |
|
rabdul
Starting Member
3 Posts |
 Posted - 2011-01-25 : 12:00:22
|
| Hello Team,I am trying to use SSIS and import the Visual FoxPro(VFP) database/table or SSIS package into SQL server 2008 R2 management Studio (SSMS) and query the package to get the desired information from the package. And also want this package to get auto updated on regular basis. Steps done so far: Created a package using BIDS and imported the package into SSMS. I can see the package under File System under SSMS integration service. Could anyone please guide me whats the next step after importing the package? My task is to query the package to get the relevant information using SSMS and want this package to get updated on regular basis(may be after 3-4hrs), so that the package has latest data from the FoxPro database.Thanks,Abdul |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-26 : 11:55:23
|
| package doesnt store any data. so didnt understand what you meant by package to get updated on regular basis. can you elaborate? are you telling about automatic execution of package periodically? if yes, what you want is sql agent job.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS and VFP