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

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

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

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

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

I have a stored procedure that calls xp_Cmdshell to extract a PDF file from a blob to disk. In the stored procedure it does something like this. ... ... ... DECLARE @bcpCommand varchar(1000) -- Command SET @bcpCommand = 'bcp "SELECT Invoice_PDF_Image FROM [MyDB].dbo.[Invoices] WHERE...

I have a SSIS package on SQL Server 2008 that accepts three parameters. The SSIS package has the parameters defined in an XML configuration file. In the scheduled job step that points to the dtsx SSIS package, I have specified the variables on the 'Set Values' list ( eg...

I believe you can only have one SSRS Report Manager site per SQL Server instance. Can two instances on the same server have two SSIS Report managers? Dazed and confused. Remember.. 'Depression is just anger without enthusiasum'.

What is the intended scope of a Shared DataSource in SSRS?. Is the Microsoft way of thinking to use a defined Shared datasource in a solution/project to serve reports only in the solution/project or is it intended that a Shared Datasource could be used by many different solution/projects...

Is there away to look at a report definition in Report manager and list the linked reports that are based on it? Seems easy to delete an original report thinking it is not used only to find out later that a linked report somewhere else in the Report Manager structure needs relies on it when a...

All, I need a way to record text against a report or report solution that does not appear on the report but is easy for a report writer to maintain to see when the report was created, the author, the request reference, the requester and a brief description of what the report has been...

I have set up a report which takes data from an Iseries/As400. However there are two separate installations of an application on the Iseries/As400 in different locations. I would like to use the same report definition for both locations. Is it possible to make selection of a shared connection...