Search results for query: *

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

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

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...

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...

Hello, I am trying to do in vb script the following: - I open a excel file, go to the spreadsheet 2 and save that spreadsheet as a csv file. Then, I close both documents and delete the excel file, just remaining the csv file. Can you help me doing this? Thanks

Hello, I have a dts package that converts Excel spreadsheets to CSV files. some of the columns of the excel file that contain numbers are not converted properly (some of the values are blank). If I convert the file directly from Excel it works ok, but not from the dts. Can you help me? Thanks

Hello, I have a dts package that converts Excel spreadsheets to CSV files. some of the columns of the excel file that contain numbers are not converted properly (some of the values are blank). If I convert the file directly from Excel it works ok, but not from the dts. Can you help me? Thanks

Hello, I have a DTS where I wanted to pass the information of an excel file to a temporary table. The problem is that my excel file don't have column names, the first row has values as well. How can I configure it so it let me pass the first row as values instead of the column headers? Thanks

Hello, I was trying to unzip a file in a dts with the following code: Function Main() strFTPDir = "c:\zip_source" strFileNameBase = "TEST" strPublishDir = "c:\zip_destination" Set WshShell = CreateObject("WScript.Shell") strUnzip = "c:\pkunzip.exe -e " & strFTPDir & "\" &...

Hello, I was trying to create a DTS with a main package wich call another DTS. If that package fails, i want to send an e-mail reporting the error. The problem is when I execute the DTS and the package fails the send mail task is not run. Can you help me solving this? Thanks

Hello, I have a problem with the drills. I have the hierarchy Time wich have the attributes year,quarter, month and day. I have two fact tables. My fact_table1 have month and my fact_table2 have day. When I have a report with the fact_table1 and the attribute month and I try to do a drill to...

Hello, I have a source file that is zipped. I want to create a DTS that unzip the file and then use that file to load data into the database. How can I do this? Thanks

Hello, I need to learn how to work with Microstrategy Web. Anyone can help me finding some information how to explore it? Thanks

Hello, I have this error because I have in my report 2 metrics One has a filter associated where I say that the column create date in the fact table has to be <= than the month My metric 2 is just a sum When I put a filter in the report to show me only the months of the last semester it...

Hello, I have a fact table that have 2 dates, the date of the creation of an order and the date of the completion of the order. I want to create a filter where I say that the create date is in the current month. I want to do the same to the close date. Now What I want is to create a report...

Hello, I have created some documents in MSTR 7.2.3 and I can see them in Desktop. When I try to see them in the Web, the pictures don't appear. I have created a folder with all the pictures in the server but I cannot see them anyway. Can you help me? Thanks

Hello, I have a metric that has the following values for months: January - 1 February - 2 March - 3 I want that in the report appears the following January - 1 February - 3 March - 6 I want that the value of the month is the sum of the month plus the previous months that are in the report...

Hello, I have one report with a metric that sums a value and that have the attribute month. In the fact table I have the code of the month and I have just one table with all the dates (year, month, day, etc.) The problem is that the result should be 1 but it gives me 31, 1 for each day of the...