Search results for query: *

In my DTS I want to schedule an import of a text file to a table in SQL. I already have this and it works great. What I would like is to get an email letting me know when there isn't a file to import. I tried attaching a send email task to the transformation but that didn't work. Any ideas?

Is it possible to have a DTS look for a file with anyfile name in a folder? I would like to import a text file that the file nmae changes everyday.

Hello all, I am trying to create a variable in a DTS that is a date. What I am doing is this: Dim CurDate CurDate = Date What this gives me is the full date. What I would like to get is just the month and year like this 04/04 How do I format this? Thank you

Is it possible to change a .dat file to a .txt file in a dts? I tried but it doesn't recognise .dat.

Is there a way to manually run a DTS through access? I need to give the user a way to run this DTS without having them use SQL. Is it possible?

I am trying to modify a macro with VB and I need to be able to select a range where ther is only data. What I have now is this Range("A2:H9").Select. I know this just selects what I have put as a range. How to I just select a range where there is data only. The range may grow or shrink...

I have an event procedure that needs to apply a filter usinf a menu item. In my code it is asking for menu version. How can I find out what menu version I have? I am using Access 2000. It seems the menu version that it automatically places in the code is incorrect. Please help. Here is my...

I have an update query in access that gives me an error when I try to run it. the error says "Operation must use an updateable query" What does this mean? How can I fix this? The table that it is trying to update is in SQL, does that matter?

I have a text file that is sent to me every week. I would like to create a DTS that can look for that text file so I could import it into a table. No here is the problem, the name of the text file changes everytime it is sent. The name of the file is usually the date that it was sent. How can...

I am trying to use DTS to import a text file into an access table. This works fine, but now I want to import the records from that text file only if it doesn't already exist in the table. Is this possible in the transformation? The table key is the primary key. Here is what I got in the...

I have a DTS that runs a few commands. One of those commands that I want it to run is to run an Access query. I guess this might be an activeX task but I don't know how to do it. I am a beginner so I don't know where to begin. Oh also the DB has a password to enter. Thanks in advance for any...

I have declaired a public variable to hold a value that is selected from a pop up form combo box. I would like to use that value to filter the records that open in the next form. How do I reference back to that variable and how do I use that to filter a form? Here is the code that I have to...

I have an activeX script in a DTS that runs a query in Access 2000. I am having a problem cause everytime I run that script I have to put in the password manually. Is there a way for me to include this in my script? Function main() Dim objDB Set objDB =...

I have an activeX script in a DTS that runs a query in Access 2000. I am having a problem cause everytime I run that script I have to put in the password manually. Is there a way for me to include this in my script? Function main() Dim objDB Set objDB =...

I have a form that opens up automatically when the database is opened. On this form I have a combo box that the user will have to select their project that they are working on. Is it possible to store the project name that they selected so I could use that to auto fill other areas. Like certain...

Is it possible to run a access 2000 query from a DTS? IF so how can this be done?

Is it possible to run a access 2000 query from a DTS? IF so how can this be done?

I am using a DTS to export from an Access table to a text file. How can I specify the length of each field once it is in the text file? The text file is being used for another application that needs specific column width when importing that information. HELP

I am using a DTS to export from an Access table to a text file. How can I specify the length of each field once it is in the text file? HELP

I created a DTS to export first_name, last_name, id from an access data base and populate a text file with that information. What I would like to also do is add two additional columns to the text file that that is not in the source table and give those columns a value of finished, and 12345...