Recent content by balistikb

Well what I am trying to do is have a simple way for a user to run a DTS from access 2000.

where do you name the dts package to run?

I am looking to do the same thing from access. I need to run a dts from access. It is a simple run, no logging or anything extra. I would just like the user to be able to run the DTS from access. Could someone please help?

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?

Ok is the @cmd @FilePath @FileNameMask all things that I need to declare? As well as @File @FileName? I am not really sure where to begin. I did read through the link and I am not sure what order things need to be done. This is why I asked for help understanding the code. Forgive my...

Ok, it seems that you are suggesting a couple of solutions. I am new to this so what do you think would be easiest for me to duplicate? I tried looking at that link and I can't really comprehend what is going on. Please Help.

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.

Isn't there a way to jus format the date?

Hello all, I just wanted to ask another date question to this post. I want to retrieve the current month and year but I am trying to get it like this 04/04. this is how I am doing it in a DTS: Dim CurDate CurDate = Month(date)&"/"&year(date) What I get is something like this 7/2004 How can I...

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

Can you explain what that command is doing? Break it down so I can understand. Thanks, I am new to this.

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

Ok I will try. Thank you.

But can the DTSRun utility get exicuted from Access?

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?