-
- Scheduling an Encrypted Package
by dgrm44
- 14 Replies
- Last post
by dgrm44
- I have a package that I have set the protection level to EncryptSensitiveWithPassword. How do I setup SQL Agent to run this package. I have checked books online and google and can't find a decent article that walks you through the steps of setting it up...specifically how to use the /DECRYPT switch with sql agent.
-
- Open SSIS project error: Unable to cast COM object of type
by Steve Wang 2006
- 10 Replies
- Last post
by bobl987
- When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong
TITLE: Microsoft Visual Studio ------------------------------
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM
-
- Sending one message to multiple consumers
by proof
- 7 Replies
- Last post
by Sergio Silva
- Hi Remus
What if I need multiple clients to read (RECEIVE) the same message
Would it be possible
Thanks
-
- The request failed with the error message
by waslam
- 2 Replies
- Last post
by waslam
- I have SSRS installed on a web server and points to another SQL Server with the ReportServer database. Every now and then I would get this error message on Report Manger:
Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.
Here is a trace from Stack Trace from ReportServerWebApp log file:
<Header> <Product>Micr
-
- Sql server 2005 trial edition
by red60man
- 3 Replies
- Last post
by Milos Cimfl - MSFT
- Hi , i am trying to install Sql server 2005 trial edition , There were 3 types of files for download Self-extracting executables: X86 Executable X64 Executable IA64 Executable Didnt know for which they are applicable , i have a windows xp professional SP2 I downloaded "X86 Executable" . Then tried to run the setup.exe file . It says installing Sql Server 2000 but i want Sql SERver
-
- Creating user to own schemas?
by windthorstking
- 4 Replies
- Last post
by windthorstking
- I have noticed that some folks create a user to own a schema, with both having the same name (ex: userowner = pfm schema = pfm) and others make dbo the owner for all their schemas. From what I can tell, it doesn't really matter; what does matter is if your database users are granted access to the schema. Since most users only have public rights and dbo has database owner rights, is there any part
-
- Line Chart Colouring
by Emil Xavier
- 0 Replies
- Last post
by Emil Xavier
- Hi,
I have a chart with chart type set to "stacked column". I have two values being displayed in the chart. One which contributes to a stacked column representation and another which has been set to "Plot data as line" under the "Appearence" option. The idea being to a marker above each of the stacked columns so that an "action" can be provided. I am try
-
- Can someone help me in understanding the output of this TSQL script
by lndsouza
- 6 Replies
- Last post
by lndsouza
- declare @startdate datetime
declare @enddate datetime
declare @testvalue datetime
set @startdate = '2005-12-31'
set @enddate = '2006-12-29'
set @testvalue = '2006-05-17'
if convert ( varchar ( 20 ), @testvalue , 102 ) between convert ( varchar ( 20 ), @startdate , 102 ) and convert ( varchar ( 20 ), @enddate , 102 )
print 'yes'
else
-
- How do I do this with SQL Express?
by 2326ac
- 1 Replies
- Last post
by Andrea Montanari
- Hi,
In Microsoft Access when I had a one-to-many relationship between tables, I could (in the master\parent) table enter a record and a plus symbol would appear enabling me to enter the many side details. How can this be done in SQL Express
Thanks for your help A
-
- Redirect Rows Move good and bad recs to bad table.
by Gal1
- 8 Replies
- Last post
by jaegd
- I use a redirect row method for error of OLE DB Destination For sqlServer2005.
For some resone even though only 1 record has error and should be redirect, all the record in the current batch (I think depending on the "maximum insert commit size") are redirect. the only way for me to get the exact bad record is to set the above parameter to 1, but then it takes hours to run the package
-
- Native Oracle SQL -> SQL Server 2005 CE .sdf file -> using Visual Studio 2005?
by Jay Tee
- 5 Replies
- Last post
by Jay Tee
- I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as: select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table There's also a CASE statement in there with some other data transformations. Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Ser
-
- Keep group together
by GraemeH
- 3 Replies
- Last post
by Shyam Sundar
- Is there any way to keep a group header and detail rows together so I don't get the header on the bottom of a page and the details orphaned at the top of the next page
Table Keep Together property only works at the table level (though not sure how that works anyway). And I don't want a page break before each group.
Thanks in advance.
-
- Print Query
by BilalShouman
- 7 Replies
- Last post
by Louis Davidson
- Hello
I wanna ask if there is a procedure that prints out a query result
example : exec sp_print 'select * from test'
Is there sthg like that
Regards
-
- Reporting Services, pivot function or union on MDX
by Joos
- 2 Replies
- Last post
by Joos
- I have to build a rather simple report with only one chart. The chart has to show a 100% stacked bar chart, with the VBS members as series.
I have 2 measures, subscriber count and total revenue. Now I want 2 bars: a first one showing the vbs stacks on subscriber count and a second one showing the vbs stacks on total revenue.
Because subscriber count and total revenue are measures, I cann
-
- SQL Express & Visual basic 2005
by Sathyan.C.K.
- 3 Replies
- Last post
by Arnie Rowland
- Hello,
Iam new to Visual basic 2005, I have installed SQL Express and prefers to use ADODB to connect to the database.
This is the code i tried
con.Open(cstring1 = "Provider=SQLNCLI.1;" _
& "Server=(local);" _
& "Database=D:\VS 2005 Projects\MyDB.mdf;" _
& "Integrated Security=SSPI;" _
& "DataTypeCompatib
-
- Job Site Searching Resumes How to store and search?
by Scott_wb
- 5 Replies
- Last post
by Scott_wb
- I am building a generic job site and well I have hit a speed bump. I need to store resumes in the database to be searched on. Well what is the best way to store these full text resumes so that they can be easily searched on SQL 2005
-
- Replicate to other server if replication with main server failed ...
by NagaPutra
- 1 Replies
- Last post
by Mahesh Dudgikar - MSFT
- Let say I've 4 server with MS SQL 2000 installed and I want all of them having the same data. So I'm using merge replication by assign one of them as publisher/distributor.
The problem is when ( let say ) server that have been assign as publisher/distributor down then all the other server cannot make replication.
My idea was to make it replicate to other available server ( among them ) if re
-
- Run Report with specific Records.
by WoFe
- 1 Replies
- Last post
by SNMSDN
- I am not sure where i should post this question since it falls both in Report Server and T-Sql but here goes...
I currently need to run a Report that has only specified records that the client/user wants by clicking the check in the check box next to the record they want. They can pick as many or a few of the records that want then run a report only with the records they indicated they wanted..
-
- Another nested SQL question
by windthorstking
- 8 Replies
- Last post
by windthorstking
- I am trying to get a nested SQL statement to work in my main SQL report code below. I can successfully run the nested code by itself and the main code by itself, however, I am having some trouble getting them to work together. [Note: the chart_components table and the episodes tables can be linked via the episode_key field ]
SELECT
srm . EPISODES . MEDREC_NO ,
srm . EPISODES . A
-
- SQL Server on Windows CE 5
by Jaydutt Shukla
- 1 Replies
- Last post
by Mike Wachal - MSFT
- I read somwhere that the CAB files needed for installing SQL Server CE on a WinCE OS can be obtained with SQL Server 2005. Does Express edition have those files I also read that same files are also distributed with VS2005. Since VS2005 is a development product, what are distribution for those CAB files when packaged with VS2005 Additionally, there is SQL Server CE 1.7MB separate download but I fou
-
- is there a unique row id hiding behind the scenes?
by db042188
- 11 Replies
- Last post
by Arnie Rowland
- I've heard that if one doesnt have a clustered index on his/her table, that clustering occurs on some underlying row id. Is this true If so, is that id retrievable
-
- Display subtotals and grand total
by JayaC
- 4 Replies
- Last post
by DanR1
- Hi,
I have a table:
CREATE TABLE [dbo] . [TBL_REPORT1] (
[Source] [varchar] ( 3 ) NULL,
[Contract No] [varchar] ( 15 ) NOT NULL,
[Business Group] [varchar] ( 4 ) NULL,
[Customer Name] [varchar] ( 50 ) NULL,
[Equipment Description] [varchar] ( 20 ) NULL,
[Lease Type] [varchar] ( 2 ) NULL,
[Term] [int] NULL,
[Booking Date] [datetime] NULL,
-
- New Data Source VB2005 and Access 2007 beta
by lowdown762n
- 2 Replies
- Last post
by Barry Andrew
- Well I'm hoping I'm asking this in the right place. But probrably not. I am using VB2005 express and have Access 2007 beta. When I try to add a new data source VB is looking for a .mdb database type. However Access 2007 beta uses .accdb. I'm not sure how to get these two talking since in the vb drop down boxes all it list is a connection on access with .mdb and all files. When I try all files and
-
- DTS Migration Wizard error
by windthorstking
- 5 Replies
- Last post
by windthorstking
- I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message:
DTS Migration Wizard Error
Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the fil
-
- LAst order date
by begunrom
- 1 Replies
- Last post
by Bryan C. Smith