Search results for query: *

I am using the WMI Event Watcher Task to watch for the arrival of a file. I have the following entered into the WqlQuerySource field in the WMI Event Watcher task. When I run it, the task turns yellow but does not find the file when it shows up (stays yellow until it times out). SELECT * FROM...

I have done some additional testing and found that I could zip a file from my pc and place it on the server in the folder I'm using and dbmail sends the .zip file out without any problems. (I'm using 7-zip both on the server and my pc) So maybe it's the way I'm zipping it?? (though it opens up...

No, no "...", it's just a long path so I shorten it. So I'm gathering that there is no reason why the .zip file is not emailing (like sp_send_dbmail doesn't work with .zip files), is that correct? Is there a log somewhere that would provide more information as to why it fails? Unfortunately...

I am hard coding the file name in sp_send_dbmail like this: @file_attachments = 'C:\SQLServer2008…\TheFile.zip',

I am zipping a file using an Execute Process Task and sending an email with the attachment using an Execute SQL Task (using sp_send_dbmail). If I do not zip the file, the email works correctly and the attachment (an .xls file) is sent with no problems. However if I zip the file and run the...

Before we purchased our new server & SQL '08, I did all my development on a vm. However now I'm having issues moving my SSAS packages from my vm to my production server (and I'd prefer not to recreate everything I've done). I receive the following error for each of my data source views -...

Being a little analyst who was recently drafted (oh, I mean volunteered) into this DBA position, I’ve had to ask our network guy what you mean, he confirmed my users and group setup. BUT as it turns out, we recently purchased a new server for our SQL ’08 and the server’s fire wall was...

Thank you for your reply. I must have something else set up wrong then because I still can not create a connection to my cube from Excel. I noticed on a sample that in the SQL Server Config Manager, the Analysis Services was set up to Log On as Local Systems, I have mine set to Log On as...

I am very new to SQL BI – so please bear with me … I am trying to give a Windows group access to a cube I created in SSAS. I created a role in BIDS for my SSAS project, but could not find where I give the Windows group access to my cube. Thinking I created the role in the wrong place, I went...

Oh, I got! (duhh!!) Thank you so much for all your help!

Sorry, I guess I don't understand. I loaded my file so it looks like this - one field named myInputField: "H ABCDEF GHIJKLa xxxxx xxxxxxxxxx xxxxxxxxxb xxxxxxxx xxxxxxxxxxxx xxxxxxxx" And in a query window I entered: myOutputField:Left$(myInputField,1,15) & Chr(13) & Chr(10) &...

Hi everyone, I need to export a fixed width file from Access 2002 (or 2007), which I know how to do in a query. However my file layout requires two carriage returns in the middle of the file – so it will read something like: H ABCDEF GHIJKL a xxxxx xxxxxxxxxx xxxxxxxxx b...

I've never tried before, but I'd like to give it a try! I'm not sure I understand how to run it. I've used VBA in with my forms quite a bit, but I always link it to a button or process - can you give me a quick explanation on where & how to use the code? Thanks!!

I receive a .txt file each week where the first few columns are basic product data, and the next eight columns are upcoming weekly forecast numbers. The column headings for the forecast numbers is the appropriate Sunday's date, ie 8/19/2007, 8/26/2007. I am appending this data to a table, and...

I have a main form, subform, then a subdatasheet form. I want the datasheet's default to be expanded. I have changed the table properties – Subdatasheet Expanded to Yes, I have changed the properties in all the forms to Yes, yet my datasheet still opens in hidden mode. What am I doing wrong...

The comment for the part is specific for that part, for a particular project. So a part could be used in several different projects for several customers, but the comment is unique to each customer/part. It seems that your suggestion would apply a comment based on a part, no matter where the...

I have a main Customer Information form, and within that form I have a Project subform for all the projects we're working on with that customer, and within the Project subform, I have a Parts subform where the user enters all the parts required of that particular project. I now want to be able...

Worked like a charm! Thanks so much!

I have a subform that has two combo boxes, box 1 gives a distributor's name and box 2, which is based off box 1, lists the distributor's branches. I want my user to select a distributor from the first combo box, then the second combo box will return only the branches associated with this...

There’s probably a real simple answer to this, but I just can’t figure it out. I have a basic query with a parameter prompting for office locations. I want the end user to be able to select either a single or multiple locations – I thought IN would work perfectly but I'm unable to get any...