Recent content by rsx

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 Catadmin, thanks for responding! I have just found an article that solves this problem: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=241941&SiteID=1 apparently the password encryption is irrelevant. Hope this helps!

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

Thank you everyone for your replies! Very helpful :)

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.

haha no problem Phil, thanks guys!!

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

Thanks guys! Very helpful :)