Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC Data
Sorry, when it downloads from the ISAM database it downloads into a temp table on the server and works on the data there. I was just wondering if there was any way to filter out records that already exists in the SQL Server table on the transformation stage of the dts package as you would using...- Iainn
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
ODBC Data
Hi all, Could someone tell me if it is possible, and if so, how, to filter out records from an ODBC data source which already exist within my SQL server database. Every hour my dts package is brining over 50000 rows from the ODBC data source into a temp table, working on the data locally and...- Iainn
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Send email from form
It depends which email program you are using. We currently use Netscape and Access doesnt have a netscape library so have to use the MAPI configuration. This means that I have to use the SendObject command, filling in the 'To' and 'Message' boxes with the controls from a form, such as...- Iainn
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
No Current Record when converting to Access 2000 runtime
I have spent a long time creating a database in Access 2000 while the rest of my company uses Access 97. However, we want to move away from 97 because of licencing issues so I suggested we use Access 2000 runtime. Therefore, after developing the database and using the Package and Deployment...- Iainn
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
