Search results for query: *

Hi all...I have a reporting challenge, and I am wondering what the best way to handle this in a cube is. I have essentially two fact tables. I have an account event type table that looks something like this: The account Referral table: Date Acct Status Balance TreatedDt 1/1/08...

Hi there, I am trying to get a report to export to a pdf or xls file at a specific location using a command line action. I got the example for Publishing sample reports to work at the following site: http://msdn2.microsoft.com/en-us/library/ms160854.aspx. I am trying to modify this example to...

Does anyone know how to programatically find the start time of a job that only has one step? The problem is, the job has not written any records to sysjobhistory yet, so no info is availabe as to when it started. xp_enum_jobs will tell you if it is running, but not when it started. I am...

Running a SSIS Package with an ODBC connection poses specific problems that force you to take extraordinary measures to run them in a job step. I am no expert here...what follows if my understanding after researching the problem. Posts to add clarity and alternate solutions would be...

I have a tricky problem. I have a file of customer notes that I import as one long text string. For some reason, although I specify the column width, the import randomly truncates the text of a few of the fields. For example, a record that reads: ADDED 1234567890123456 NEW: SOMEDATET...

Hi all, I would like to use SSIS to transfer over data to a destination, but use a symmetric key on the destination server to encrypt data columns. The idea is to use something like: EncryptByKey(Key_GUID('sym_dbEncryptionTesting'), SomeField)... I could easily transfer the data as cleartext...

We have a frustrating problem with a summed field in our cube. Basically, it is like this: We look in the fact table and see that the sum of a particular field (tinyint) is, say, 652. When we pull up the aggregation for the user, the cube shows 650, two short of the total. This obviously...

I wanted to run this question past all of you smarties out there to see what you thought. We are bringing in large amounts of data from an Oracle 8i server into our SQL Server (2000) in order to build a customized data mart. Our experiments show that having the data local is much faster than...

Hi folks, A challenging problem (for me!). I need to import any one of 25 large fixed width text files when the following two conditions are met: 1. The file exists (has been downloaded) and 2. The download process has finished writing to the file (file not in use). Basically, when the...

I would like to retrieve data from mainframe (AS/400) flat files using SQL Server tools, either by querying or linking directly to the file (my first choice), or by FTPing datasets using a DTS package or stored procedure to a local drive and importing the data from there. I tried the FTP Task...