Recent content by AnaFlor

Yes, it copies a file to a another folder and then uses that data. But I was trying to do a test with a sql task with just a select * from table_a and the schedule didn't work also.

Hello, I have created a DTS that runs perfectly. When I try to schedule that DTS it gives me an error that is trying to find some file that does not exist. Any idea what seems to be the problem? Thanks

Hello, I scheduled a dts, but when my dts is running by it, it gives me the following error: The job failed. The Job was invoked by Schedule 55 (TEST). The last step to run was step 1 (TEST). What is the problem? Can you help me? Thanks

But then, where can I find it? Because we didn't create any stored procedure in any machine, and in any database. Thanks

Hello, When I try to associate an e-mail profile in the properties of sql server agent it is giving me the following error: Could not find stored procedure 'msdb.dbo.sp_set_sqlagent_propoerties'. Do you know what is the problem? Can you help me solving this? Thanks

Hello, When I try to associate an e-mail profile in the properties of sql server agent it is giving me the following error: Could not find stored procedure 'msdb.dbo.sp_set_sqlagent_propoerties'. Do you know what is the problem? Can you help me solving this? Thanks

Thanks for all your help.

TomThumbKP, I was trying to do what you said and it is giving me the correct date: 09/05/2004. So the first step is correct. Now, I have to check if this date is less or equal than 7 days to the end of the month.

The problem is that the date is in the column 4 of that file. what if I check the date in a temporary table. in that case, in dts I load that date to a temporary table wich have only 09/05/2004 and then make a code to compare the end of the month with that date? is it easier? Thanks

How can I setup correctly?

Hello, I create a dts that if the file does not exists, I receive an e-mail telling that. The e-mail that is set to be the sender is mine. The problem is that when I run the dts from my computer it works fine, but when I schedule the dts or when I run that dts from the server it doesn't work...

the date is always in line 1 and it starts at character 34

can you explain me a little more please? I don't know much about vb script. I start learning last week. the logic is less than or equal to the end of the month, I wanted to say is less than or equal to 7 days before the end of the month Can you help me? Thanks

Hello, I am trying to do the following: - I receive a file every week. In one line of the file I have something like "Values from 03/05/2004 to 09/05/2004". I need to check if the last date of that line of the file (in this case 09/05/2004) is less than or equal to the end of the month...

tsuji, it worked perfectly thanks