Search results for query: *

Hello Is there a way to find out what web reports use a particular table? Thanks.

Hello In our current cognos environment we have allowed users to schedule/email reports and unfortunately this privilege has been abused. The server is overloaded and does not complete all the scheduled jobs. We would like to keep the schedules but take back the ownership. We have over 1000...

Hello I have set a variable using a Script Task that assigns a select statement. This works fine. However, when I select the variable in the data flow object ( within the OLE DB Source object ) I receive an error saying "Command text was not set for the command object" I am using the script...

Hello, I am hoping to come up with a clever select statement rather than using a loop. Problem: I have a codes that have transactional amounts for each code at various times of the month. So: Code 1234 Jan 01,2007 $100 Code 1234 Jan 15, 2007 $100 Code 1000 Feb 01, 2007 $200 Code...

Hello, I have a master package that calls other packages. One of these children packages is password encrypted. I have entered this password into the Execute Package Task editor in the master package. However, when I run this task it fails when calling the password encrypted package with the...

Hello, Has anyone connected to JDE (ibm db2) through Sql Server 2005 successfully using an ole db driver? I am getting defaultcodepage errors and i am not able to get a table list drop down. Thanks for any help.

Hello, Is there away to change the date to start April 01, instead of Jan 1? I need to calculate which week any particular day of the year would be. So April 01 - April 08 would be week 1 and so on. Can the DATEPART function be used some how? Thanks in advance.

Hello, I have an MS SQL Server DTS package that truncates a table, drops/creates indexes then inserts new data (about 10 million rows). There are about 11 indexes on this table which is being used for reading, specifically for reporting purposes. During execution the database log file...

Hello, I have recently noticed a fair bit of data missing from a table in one of my databases. Is there a way to view the transaction log file for a particular time period to determine who or what deleted these records?

Hello, When I a run a script to create tables (SQL Server 2000), I notice that columns defined with char are given a collation by default: COLLATE Latin1_General_BIN How do I remove this? Could this be responsible for slow retrieval via MS Access linkage? Thank you.

if i have numbers in column A and i want column B to represent the numbers in A divided by a number in one particular cell, how can set this formula by dragging? eg. B1 = A1 / C1 B2 = A2 / C1 B3 = A3 / C1 etc.. Thank you..

hello i am querying a table for data with a specified date range. eg. date between '12-1-2004' and '12-31-2004' i am not picking up data on the 31st with this filter. however if i use: date between '12-1-2004' and '1-1-2005' i get data on the 31st and nothing on the 1st of January...

Hello, Can someone tell me the code to build and generate (new) categories for a cube from the command line? Thanks very much.

hello, can someone show me the code for setting up a step within a job to execute a dts package? thanks very much..

Hello, I have a dts package on Server 1 importing data from Server 2. Values in a table from Server 1 are needed to filter the extraction on Server 2. Is there a way to do this? Thanks for any help.

Can someone tell me how to link to a stored procedure thats sits on sql server through ms access? thanks..

Can anyone please tell me if indeed it is possible to pass filter criteria to a crosstab report from a power prompt application. *My filters are valid. Thank you.

Can anyone tell me if an impromptu crosstab report can receive parameters from a power prompt app?

Can anyone help me set up a text file as a data source so the dynamo can read it properly? I want to insert month names from a text file into a drop down selection box and pass that selection to the report for filtering. Thank you.