Search results for query: *

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

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

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

I have a need to extract data to an Excel 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...

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

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

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

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

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

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

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

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

I'm trying to expand my humble SQL query skills and I have stumbled across the CROSS APPLY. I have an example from a book and I kind of get it but I just want to clarify a few things. I want to understand when you would use a CROSS APPLY and what the benefits are. It seems to me the benefits...

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

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

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

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

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

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

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