all groups > sql server dts > may 2004 > threads for may 29 - 31, 2004
Filter by week: 1 2 3 4 5
Linked Server and Foxpro
Posted by MikeD at 5/31/2004 12:41:05 PM
I need to update/insert reconds into an existing Vfoxpro database from Server2000.
I set up a linked server using a VFP ODBC Driver. I can see the table in EM.
In QA I can do a select using:
Select * from Openquery(LinkedServerName,'Select * from MyTable order by Col_PK')
This update statem... more >>
File Names In Table
Posted by DB_Princess at 5/30/2004 10:46:03 AM
Guys
I have this great DTS package which I created from a looping example y'all pointed me towards. Just when I was about to put it into production, I was told that I should not have hardcoded my file names. Well, the purpose of the looping was that the file names changed daily and I wanted to p... more >>
Importing and exporting between VB.NET and SQL Server 2000
Posted by Therese at 5/30/2004 12:40:52 AM
Hi! I have current project wherein only certain fields in
the tables in SQL Server would be extracted and
transferred to a new Excel file. The thing is, data
extraction would be done through the front-end, Visual
Basic.NET form, and this would be performed by clicking
the Extract comman... more >>
Scheduled DTSs.
Posted by Adam David Moss at 5/29/2004 3:42:07 PM
Hello,
I have a number of DTSs scheduled under SQL Agent. The first step of these
DTSs is to check if a file exists (said file gets FTP'd from a mainframe).
As the exact time the mainframe job sends the file cannot be determined (the
time the job is eligible to run is known, but depending o... more >>
|