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

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

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

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

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

Just when I thought I had found the solution (faq181-271)for my form data to mail merge in a Word.doc (and in plain language I can understand!), I can’t seem to get it to work. I’m using office 2003 – I have written my query, and it returns the data as expected. However, when I go to create my...

I am wanting to create a macro that imports a dBASE table. As I understand it, the third argument (Database Name) requires the full path of the table, which changes continually for me. Is there a way to leave this argument blank and have it prompt for the path each time? Thanks for the help!

Can shared variables be used in a report that is posted to the CMC? If so, how do I accomplish it?