-
- Linked server from Sql 2000 to Sql 2005
by T_EC
- 3 Replies
- Last post
by T_EC
- I'm having issue in connecting to sql 2005 from sql 2000 via linked server.
Please advice what I should do to overcome the problem.
Thanks.
-EC
-
- web parts with ie7
by vjn
- 0 Replies
- Last post
by vjn
- Hello, I'm using RSWebParts in a SharePoint page. The Explorer and the Viewer web parts worked fine with IE 6 but now I'm using IE 7 and when I choose a report in the explorer to be opened in the viewer it opens a new browser window with the report instead and the viewer stays empty. I looked into the source code and I think thai it's all ok. Does someone passed by something like this Any solution
-
- range comparison
by Andrew Todd
- 3 Replies
- Last post
by Jarret
- How would one go about writing an expression such as:
var not in (a to g, s to z) in the expression builder to be evaluted with and iif statment
iif(var not in (a to g, s to z),var,"not in listed")
I would rather not have to write this in the SQL statement as a case statement.
-
- SQL installation paths
by chittam
- 6 Replies
- Last post
by chittam
- Hi
I have sql 2000/2005 installation path errors in some of prodution servers. Like we have standards that backup files should go to E:\ drive and data files to f:\ and log files to h:\. Can any one help me in this issue what can be done with out reinstallation,
Thanks in advance
-
- Am I physically connected to the server on the computer I am using
by Doug Marquardt
- 8 Replies
- Last post
by Arnie Rowland
- Hi All:
Is there a way to tell if I am connected to the server on the computer I am using to connect with
I want to determine whether the connection is to the local server or a remote server.
Thanks.
Doug.
-
- SSIS - Connection String Issue
by MA2005
- 14 Replies
- Last post
by Phil Brammer
- Hi
I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format:
I have two conn strings specified in my config file, one is to connect to a remote database and one is
-
- How to embed word/pdf object into report?
by leshan01
- 6 Replies
- Last post
by BobP - BIM
- Hi, I have a report which includes all the customer data. each customer have a separate page based on their id.
For example, the report is 10 pages and each page is data for one customer.
Now we need to insert the instruction on the second page of each customer report. that means we need
to insert 10 instructions on the above report so each customer will get one page of data and one page
-
- what is SOS_SCHEDULER_YIELD?
by Handong love
- 4 Replies
- Last post
by sqlworkshops
- what is SOS_SCHEDULER_YIELD
and when dose SOS_SCHEDULER_YIELD work
if having more CPU, will SOS_SCHEDULER_YIELD be influenced by
thanks for reading
-
- use of CASE in script
by Redi311
- 2 Replies
- Last post
by Mugambo
- I have been working on a job that is supposed to do the following:
1) Imports last name, first name, date of birth, ssn, medical record number, and enterprise id from TAB seperated text file
an example of the format would be
ENTID<tab>LAST<tab>FIRST<tab>DOB<tab>MEDREC<tab>SSN
2) Looks up the person in the import system and inserts a primary key value that
-
- Regular Expressions in SQL 2005 using C#
by YoungEngineer
- 6 Replies
- Last post
by moona
- Hi all,
i wrote a little function that is basically supposed to give me a match of a regular expression in C#. i tested it out in VS05 and it seems to work fine. It hits the fan when i try it on SQL Query analyzer once deployed. Anyone have any idea why
here is the C# class that I deploy to a db using VS05.
using System;
using System.Data;
using System.Data.SqlClient;
using
-
- Cannot set numeric to null before inserting to table
by sadie519590
- 4 Replies
- Last post
by sadie
- Hi,
I have a flat file whose data looks like this:
"Opening Balance", Acct1234, 1001.01
"Closing Balance", Acct1234, 1001.01
In my script component for "Opening Balance", I set my output columns like this:
Row.AccountNumber = CDate (rowValues(1)
Row.OpeningBalance = CDec (rowValues(2))
Row.ClosingBalance = Nothing
Be
-
- Problem running SSIS from C# executable when kicked off by another executable.
by agentf1
- 3 Replies
- Last post
by jwelch
- If I kick off my C# executable from the server everything works fine but if I have another C# executable kick off the C# executable that runs the SSIS I get an error message saying it cannot run SSIS package. I am thinking it sounds like a permissions problem but not sure. Any suggestions/guidance would be greatly appreciated.
Errors I am getting.
2007-09-26 15:02:30,187 [1] ERROR report
-
- automatic update
by cirkin_kral
- 2 Replies
- Last post
by Jonathan Kehayias
- I hope that a someone has answer for me.
I want create a new database in sql server and import the database tables of Dynamics CRM and of other application (Accountview) import so that I can make a link of these two databases. My question is it possible that this database update or refresh automatic and how
The database of Dynamics CRM manages by sql server. But the database of accountview i
-
- Sharepoint Add-In Front End Configuration Issue
by Erik Miller
- 14 Replies
- Last post
by phaserkb
- I was wondering if anyone else has come acress this iss or not...
I have a distrbuted environment....I have installed SP2, .NET 3.0, and the WSS Object Model on the SSRS server and setupa database for sharepoint integration. But, my issue is with the front end web server for MOSS. I install the sharepoint add in and go to Central Administration to configure the connection and other steps, but I
-
- replace value of
by SQLScott
- 3 Replies
- Last post
by Jinghao Liu - MS SQL Server
- Can someone please enlighten me on a specific way "replace value of" is used
I'd simply like to know if replace value of can be used to udpate an empty node value. I can't get it to do that, so I'm thinking it can't, but I would certainly like to be corrected if it is possible.
For example, suppose of I have the following in a Typed XML column:
Code Snippet
-
- Visual Studio/BIDS out of memory errors opening large DTSX files
by Wil_Reed
- 1 Replies
- Last post
by Person_me
- I'm currently experiencing major problems with SSIS when opening and editing large .DTSX package files that contain Exec DTS 2000 Tasks which have the package data loaded internally. I have no issues if I point the task to a .DTS file, or to an actual DTS package on a SQL 2000 server - but if I load the package internally then once the underlying .DTSX file gets over around 17MB or so in size (whi
-
- junk character within FLAT FILE
by Antony Kumar
- 5 Replies
- Last post
by Jamie Thomson
- sample Data: "061107"
Every flat file ends with the junk character
How to remove this using "Derived Component" or "Script Component"
Pls provide the sample code for this task. Thank you.
-
- Management Studio Express for Vista
by soleil4716
- 2 Replies
- Last post
by soleil4716
- Does anyone know if Microsoft SQL Server Management Studio Express is available for Vista or not Thanks.
-
- RDL Location on the Server
by SQLChamp
- 4 Replies
- Last post
by Lisa Nicholls
- Hello,
I'm wondering where exactly is the default location of the rdl file stored on the server http://<server>/reports/
Thanks,
-Lawrence
-
- 4 part name query very slow
by John1234566
- 3 Replies
- Last post
by John1234566
- exec sp_tables_ex 'linked server'
The table_cat returned a null value. I ended up writing
select * from linked_server..schema.table and it did work. However, it was really slow. 56 seconds vs. less than a second for the pass through openquery.
My guess is that the problem is that the table_cat was null and this is why it is so slow. Is this correct How do I resolve this speed
-
- How do you send the result of a query by SendMail?
by Jayaram Krishnaswamy
- 9 Replies
- Last post
by Jayaram Krishnaswamy
- For example the result of an Execute T-SQL Statement task.
This task does not have a hook-up for variable assignment, the SendMail can take in a variable. How do you pass the result of EXEC T-SQL statement be assigned to the variable in the SendMail task
-
- How to create an installer for deploying Sql Server Express
by xs8899
- 1 Replies
- Last post
by Arnie Rowland
- Hi,
I have created an installer for deploying Sql Server Express. My installer will start the process of installing Sql Server Express. However the installation of SqlServer Express will fail because it says another installer is currently running (which is my installer). Is there anyway to work around this problem
The reason why I would like to create an installer for the installatio
-
- Reporting Services Charts
by Corey1969
- 1 Replies
- Last post
by Mary Lingel MSFT
- Hi,
I am new to reporting services and I am stuck. I have a report I am trying to design, it has startdate and end date as parameters, I als have a non-queried parameter with the values of month,week,user,hour. These parameter values create a drowndown box on the report, What I am trying to figure out is how to display information in a chart depending on which item is selected i.e (month,we
-
- expression sum and iif help?
by Nick Sheng
- 3 Replies
- Last post
by Nick Sheng
- Hi All,
SUM(IIF(Fields!NO.Value >= 1, Fields!tsHours.Value,0))
i write this expression inside the group footer row, it give a #error when generating report.
please help
Cheers
Nick
-
- Problem with transact SQL Query
by BH1234
- 7 Replies
- Last post
by JVSoares
- Event
Event_ID
Person_ID
Event
Start_Date
1001
50
Referral
02-02-2007
1002
50
Appointment
03-02-2007
1003
50
Assessment
07-02-2007
1004
84
Referral
14-02-2007
1005
84
Appointment
20-02-2007