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

...date I needed as a string friendly to implicit date conversions. This way, in my Execute SQL Task, I could put a query like: Insert into tableA select * from tableB where mydate >= ? and it would work be implicity converting my date string. Hope this helps someone...worked for me...

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