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

    RunSavedImportExport Macro - How Can You Edit Definition?

    I have inherited an Access database used to manipulate data from a supplier and import it into a database. The Access database use a Macro that performs a RunSavedImportExport step followed by two ImportExportText steps. The RunSavedImportExport step just seems to have a parameter of a...
  2. Skittle

    SSIS 2008 Configuration Files

    I have a SSIS 2008 package I want to run against test and live data sources and destinations. The way to do this appears to be to use Configuration files. I've tried to do this and come up against a problem. I have created two configuration files. One for live and one for test. I can see both...
  3. Skittle

    SSIS 2008 To Excel Number Columns Without Green Triangle In Top Left Of Each Cell

    I am extracting data from a 'Select * from MyTable' to an Excel file. Some of the columns are numbers but when extracted to Excel are stored as character fields with the green triangle in the top left of each column cell. I can of course manually convert the columns by going into Excel using...
  4. Skittle

    SSIS 2008 To Excel Including Column Names

    ...file as a scheduled job and FTP it to location. SSIS seems the perfect tool to do this. I am populating the output data from a simple 'Select * from MyTable' command. The Excel file is populated but it does not include the column names from the table. Is there a way of setting the first line...
  5. Skittle

    List Entries In Active Directory

    OK resolved it. My query listed all entries within the AD rootentry ( computers, groups, whatever...). When you try and reference user related properties against the result it blows up with property occurrence not found. Initially I checked to see if the type is a user before adding a filter to...
  6. Skittle

    List Entries In Active Directory

    I have found a bit more out by trial an error but I am still struggling. The results return a list of entries but some of the entries seem to be empty/nothing. results(0).Properties("cn") errors results(1).Properties("cn") returns a value results(2).Properties("cn") returns a value...
  7. Skittle

    List Entries In Active Directory

    I am trying to achieve my first attempt to at reading Active Directory entries into a SearchResultCollection. At this stage I'm just trying to return a list of the 'cn' property. I run the code below - with a valid DirectoryEntry address of course. The code tootles along and returns the...
  8. Skittle

    Get External Image To Point To Image File In Report Manager Folder

    Your suggestion will work for a location of a hard drive but I am looking for the ability to reference an image on a URL where the URL is a folder on the report manager server. In other words I have gone to the SSRS Report Manager intranet web page and created a new folder by clicking on the...
  9. Skittle

    Specify Background Colour On Report As Hex Number

    It does not show the impact in designer but it does when I preview the report. is there a way of showing it in the designer as well? Dazed and confused. Remember.. 'Depression is just anger without enthusiasum'.
  10. Skittle

    Specify Background Colour On Report As Hex Number

    I have a text box I would like to set to specific colour. I select the text box properties and select 'Fill'. I click on the 'Expression' option for the 'Fill Color' and in the expression type :- ="FFAAFF" This is just a random colour I grabbed from an example page. The background colour...
  11. Skittle

    Get External Image To Point To Image File In Report Manager Folder

    When adding an image to a report you get the option to select Embedded, External or Database. When I select external I can point to an image using a file reference C:\MyFolder\MyImage.jpg. I can also reference an image as a URL out there on an internet page with...
  12. Skittle

    SQL Term 'Cursor'

    I would like to clarify in my own mind what a 'cursor' is within SQL. Whenever I hear the phrase I associate it with a row by row scripted loop through a table to do some fancy row by row work. It's effectively a DO WHILE loop to read all rows one at a time and do something to it within the...
  13. Skittle

    CROSS APPLY

    ...a set of ROWS or single aggregate? Context For context, here is the example from the book. SELECT S.Supplierid, s.companyname AS Supplier, A.* FROM Production.Suppliers AS S CROSS APPLY (SELECT productid, productname, unitprice FROM Production.Products AS...
  14. Skittle

    Create A Sequence Number Within Group OF Rows

    That's pointed me in the right direction. Many thanks. Opened my eyes to a host of possibilities there. Dazed and confused. Remember.. 'Depression is just anger without enthusiasum'.
  15. Skittle

    Create A Sequence Number Within Group OF Rows

    I have a table of rows that can have a variable number of rows per invoice. I need each row number to have a sequence number within the invoice. It does not matter the sequence, I just need to generate a number. So from:- Invoice Value 00001 10 00001 20 00001 100...
  16. Skittle

    Microsoft Server Admin 70-463 - Virtual Environment

    All, thinking of doing the MCSA SQL Server 2012 Certifications. Official Microsoft Book for 70-462 requires six computers to do all the exercises. I don't have the machine to power 6 virtual PCs. Anybody know somewhere that sets up the six PCS as a cloud virtual environment of that offers...
  17. Skittle

    Formatting Field - SQL Or Expression - Which Is Best For Performance?

    A bit of a general question but curious for all opinions. I have a Crystal Report I am re-engineering into SSRS 2008. The Crystal Report has a large 'IF' condition that checks two character department field and then converts the value to a 20 character description. Clearly this could have been...
  18. Skittle

    SQL Server Profiler To Identify A Fault

    Out of interest how would you go about setting up a job to delete the files? Just a simple scheduled batch job in windows or a SSIS task? I agree the profiler hits performance but I don't know what else to will identify the problem. The windows application log shows nothing starting or...
  19. Skittle

    SQL Server Profiler To Identify A Fault

    My SQL 2008 Server has suddenly started running out of memory at random times during the day. The windows application event viewer indicates this via an MSQLSERVER error where I get errors that indicate lack of memory is preventing connections to SQL Server. This clears itself after about an...
  20. Skittle

    xp_cmdshell To Extract PDF's

    OK thanks, I'll look into it. Dazed and confused. Remember.. 'Depression is just anger without enthusiasum'.

Part and Inventory Search

Back
Top