Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shairal

    WMI Event Watcher Task

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

    SSIS 2008 sp_send_dbmail and .zip files

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

    SSIS 2008 sp_send_dbmail and .zip files

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

    SSIS 2008 sp_send_dbmail and .zip files

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

    SSIS 2008 sp_send_dbmail and .zip files

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

    Moving SSAS to new server

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

    Granting cube access to a Windows group

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

    Granting cube access to a Windows group

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

    Granting cube access to a Windows group

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

    Enter a carriage return in a fixed width file

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

    Enter a carriage return in a fixed width file

    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) &...
  12. Shairal

    Enter a carriage return in a fixed width file

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

    Referring to a column number (location) in a query

    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!!
  14. Shairal

    Referring to a column number (location) in a query

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

    Change Default 2 Expanded in Subdatasheet

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

    Creating a 4th Level Subform Issues

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

    Creating a 4th Level Subform Issues

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

    Combo box in a subform

    Worked like a charm! Thanks so much!
  19. Shairal

    Combo box in a subform

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

    Using IN in a parameter query

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

Part and Inventory Search

Back
Top