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

Wow, 36. Can't believe that works. Thanks, Dan

Duh...you're right. . Down to 37. Thanks, Dan

Sorry, got this to 41. Like I said, this won't work for all values of col1, but I think will work for A-Z. Thanks, Dan

How do I share the code without making it visible? My solution was a hack, btw. It just happens to work, but wouldn't work automatically if you added, say, "CAAAA" and "CBBBB" to the table. Still, it DID produce the results desired, though I wouldn't give me a star for it. Thanks, Dan

I got it in 44. Thanks, Dan

Another wild guess, but if you need to have a column have the same value as another column, you could just create a computed column and set it equal to you key field: CREATE TABLE [dbo].[tbl_Test]( [MyKey] [int] NOT NULL, [Calculated_Column] AS ([MyKey]) ) Thanks, Dan

Thanks for your suggestions, SQLBill. I had a little trouble with your suggestion, but it set me in the right path. Here is what I came up with for sql server 2005. This uses [MSDB].[DBO].[SYSJOBACTIVITY] and msdb.dbo.syssessions, neither of which exist in 2000. CREATE TABLE #xp_results...

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

Researching the same issue...found this:http://support.microsoft.com/kb/919904/ Thanks, Dan

OK, I answered my own question. It appears that the file does in fact have special characters. I used bulk insert to bring in the file "as is", found a row that was being truncated on select, selected the ASCII value of the character occurring after the truncation began, and discovered the...

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

Another option is to use expressions in the execute sql task editor. You could create an expression for the SqlStatementSource property. A simple example: "exec usp_SomeProc @somevar = '"+ @[User::strSomeVar]+"'" Thanks, Dan

This is an old post, but I thought this link would be useful to someone. I used this methodology to implement logging using event handlers in my packages. http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx Thanks, Dan

Unless I am mistaken, there is no way to encrypt on the source, transfer, and decrypt on the destination with the same keys. From what I have read, "persistent" encryption is not possible. If there is a way, that would be fantastic! Otherwise, I have to encrypt on the destination server or...

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

I know this is a little late, but I could see that noone had answered this, so I thought I would give my two bits for posterity. I was having the same problem, and what I discovered is that DTS was throwing the "Invalid character..." error whenever I tried to cast or convert in an Execute SQL...

The problem is the nulls. If you add an "Else" statment, then you will get a result: SELECT Col1, Col2, Col3, CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' else '' END + CASE WHEN Col2 = 0 THEN 'Col2 Is In Error' else '' END + CASE WHEN Col3 = 0 THEN 'Col3 Is In Error' else...