Integration Services :: How To Modify DTSX That Is Inside Catalogs

Nov 13, 2015

I need to modify a .dtsx that is inside ‘Integration Services Catalogs’; I tried right-clicking + exporting… But I only see ‘Configure’, ‘execute’ or validate options… I thought I could export it, directly from there, modify it and import it againNow I accessed the Integration Services from the same server name, and it’s not there… How can I find out, where is that package from? Or is there a way that I can export it directly from ssms?

View 4 Replies


Integration Services :: To Run Report On Catalogs (SSISDB)

May 20, 2015

I would like to figure out a way to give access to QA's to run and View reports on SSISDB catalog without giving them SSISAdmin or SYSAdmin permisions.?

View 2 Replies View Related

Integration Services :: Cannot See Catalogs Node In Management Studio (SSMS)

Oct 12, 2015

I wanted to create a SSIS catalog and the way to create a catalog is to right click on "Integration Services Catalogs" node and select "Create Catalog" option.

However, I am not able to see the "Integration Services Catalogs" node in SQL Server Management Studio (SSMS) as shown in the following image.

What is missing so that I can see this node in SSMS?

FYI, I have SQL Server 2014 (Developer edition) and Integration Services 12.0 installed on my machine.

ProductVersion = 12.0.2269.0 (SELECT
SERVERPROPERTY('productversion') AS ProductVersion)

View 6 Replies View Related

Integration Services :: DTSX Won't Save Variable Updates

Nov 10, 2015

I have a set of .dtsx files that connect to an Oracle database. The Oracle username and pw values are saved in variables set up in the .dtsx files.  These two variables do not have expressions, rather, these two variables feed other variables and their expressions.Theses files are now moving from one environment to another and the Oracle username and pw must be updated to connect to the new Oracle environment.

Upon updating the variables, the packages expressions update as expected, however, when saving the file to disk, the updated variables aren't saved and the values revert back to the original values.

How are variables updated in .dtsx packages that will allow changes to be saved?

View 6 Replies View Related

Integration Services :: XML Code Is Coming When Open Dtsx Package?

May 13, 2015

When I double click on dtsx package , i am getting XML code. I am unable to get the Graphical View. Recently I have installed Visual 2013.

View 6 Replies View Related

Integration Services :: Error When Modifying Existing DTSX Package

May 12, 2015

We are struggling to add an extra column to a Dtsx package.  The package essentially compiles data into a table and then exports the data to a series of Spreadsheets. So far I have ended up doing the following: -

-Creating a new Folder for the Spreadsheet Templates, copying the existing spreadsheets into the new Folder and then added the new Column.
-Creating new Connection Managers in the Package to connect to these new templates.
-Adding the column to the various data flow tasks so that the new column is converted and then exported (data type is varchar(30), conversion type is Unicode text stream [DTNTEXT]).

Everything validates when we compile the dtx package. However when we run the package we are getting the following error: -

Started:  5:39:49 PM
Error: 2015-05-12 17:45:39.05
   Code: 0xC0202009
   Source: Data Flow Task Voluntary Excel [2379]
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
End Error

[Code] ....

View 5 Replies View Related

Integration Services :: Unable To Run DTSX Package Locally When There Is A Sort Task

Apr 21, 2015

I have created a very simple package. It has a OLE DB Source, a Sort and a OLE DB Destination.

When I run it in the Integration Designer in Visual Studio, it works fine.

But when I like to execute the package in another C# Project, I get this error:

"To run a SSIS package outside of SQL Server Data Tools you must install Sort of Integration Services or higher."

When I remove the Sort Task, it works.

Here is my C# code:

MyEventListener eventListener = new MyEventListener();
Microsoft.SqlServer.Dts.Runtime.Package _Package;
Microsoft.SqlServer.Dts.Runtime.Application _Application;
Microsoft.SqlServer.Dts.Runtime.DTSExecResult _DTSExecResult;
_Application = new Microsoft.SqlServer.Dts.Runtime.Application();
_Package = _Application.LoadPackage(@"...Package.dtsx", eventListener, true);
_DTSExecResult = _Package.Execute(null, null, eventListener, null, null);

View 7 Replies View Related

Integration Services :: How To Capture Changed Data Of 2 CSV Files And Modify It In Oracle Database

May 6, 2015

I need reflecting changes of csv file in oracle DB. Suppose,  I load single csv file in oracle DB which contains 10 rows. After some time, I have loaded another CSV file which has the modified row of the previously loaded csv file. So, how can I capture the CSV changes and how it is going to get reflected in oracle DB?There is no unique column in csv file to identify particular row.

View 3 Replies View Related

Integration Services :: Setting A Condition Inside For Each Container

May 15, 2015

I am having a sql query task to fetch a maximun number. Example output : 102. After that I have a for each container to return files from a particular location. Files in the location are for example KAS.JN.101, KAS.JN:102, KAS.JN.103, KAS.JN.104. I want to lpop over only the files which have the ending greater than the maximum number returned from the sql query. In this case, the for each container must only loop over 103, 104. Chow to pass this condition to the container ?

View 6 Replies View Related

Integration Services :: Parameterize TOP Clause Inside Execute Task

Jun 23, 2015

in a SSIS 2012 pkg, I'm trying to specify a SELECT TOP ? myColumn FROM myTable inside an Execute SQL task, but unsuccessfully.Is it possible to parameterize the TOP clause?

View 6 Replies View Related

Integration Services :: Refresh Excel Sheets Inside SSIS?

Sep 15, 2015

I am trying to refresh some excel sheet I get with powerquery. After that I load the data in an sql server table to build a dummy DWH for various testing.

My goal is to automate all task and this include also the excel queries. I have seen that exits on codeplex an excel refresh task but it doesn´t work in my enviorment (SSDT 2013) or at least I have been unable to do it.

I have seen too a pragmaticworks component but I have to pay so I have discarded it.

I have tested a code that I have found in this

thread with minor changes like increase the time to refresh the excel file to 60000 and change the line

[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

and replace for


I run the script but neither fails nor does anything. It run sucefully without refresh. This is the entire code I run

Microsoft SQL Server Integration Services Script Task
Write scripts using Microsoft Visual C# 2008.
The ScriptMain is the entry point class of the script.
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
namespace ST_53932a75e92c44f086535fc017a56e6a.csproj


P.S: I have been playing with the time it needs to refresh and I have found that set the time in 80000 works fine.

View 2 Replies View Related

Integration Services :: Excel Destination With Run Date-1 Inside File Not The File Name

Aug 26, 2015

I have a ssis package where I need to have excel destination.  In the Excel file, I need to have few rows with some text and then populate data below the text. One the text is like this:

Data as of:  08/25/2015

if the report ran today, then Data as of will have Yesterday. So, if the user opens that excel file after a week, then user should see same  Data as of:  08/25/2015. not today()-day(1).

I was planing to handle on excel side with today()-day(1). but it only works the day it was run. Then the excel file is open after few days later, then it might as Data as of:  08/30/2015 which is not true. It should still stay Data as of:

 08/25/2015 on what ever date the excel file is open. The SSIS package  runs only once. 

How do I handle this so that whenever user open the file, they will see Data as of:  08/25/2015. This is not a column in excel. It is like a description of data in excel.

View 3 Replies View Related

Reporting Services :: Cannot Modify Folder Permissions

May 21, 2014

We have a SQL 2012 SSRS instance. We need to modify the permissions on one of the reporting folders. I went to the Security setting of the folder, clicked "New role assignment", then entered a group name into the box and selected desired permission ("Browser" in this case).

However this always fails with the same error: "The user or group name 'BUILTINBUILTIN' is not recognized. (rsUnknownUserName)"

I always get the same error no matter if I enter user or group, domain or local. And it always says BUILTINBUILTIN. I've tried changing the SSRS service account to a domain account (it was a local one), but that didn't work.

View 3 Replies View Related

How To Optimize Integration Pacakages Or Best Practices For Integration Services

Sep 11, 2007

Hello friends.
I managed to design an Integration service package,but the desired level of performance has not been achieved(i.e it is performing slow).
So I want to know what are the best practices for optimized solution .
In my package I'm exreacting data from XML file and Storing it in SQL server database with some processing dring data flow.

I'm using
1) Two Script Task Control -In these control,I m opening the connection to XML file through code and
iterating each record at a time.
2)Two OLE DB Command -Each fetched record from script task component is processed in OLEDB command through
stored procedure and then inseted into database.
3)One for Loop -This loop contains two script Task control and two OLEDB Command control,
(mentioned above),for fetching single record and inserting it in database.
4)One derived Column
5)One Multicast
6)One Character Map
7)One OlEDB Source

As with my current performance I'm able to insert one record in every .5 second (Which is much below to acceptable limits)
Is control lying disabled on SSIS designer pane also affect the performance of execution.

View 4 Replies View Related

Reporting Services :: Modify Report To Return Events In Progress Over Arrival Date Parameter?

Aug 6, 2015

I have a report which queries events occurring during the reporting time frame the user selects.

A user selects arrivalDateStart as 8/1/2015 and arrivalDateEnd as 12/31/2015 and the results are returned.

The issue is that there is an event that began 7/31/2015 and ends 8/2/2015. This does not appear on the report. The user does not want to have to pick an earlier arrival date as the parameter of his report to pick up anything that was already in progress prior to the beginning of the month.

I am trying to figure out how to add an expression that will also return events that are in progress over the arrival date chosen for the report.

View 9 Replies View Related

SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue

Mar 23, 2007

I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?

View 5 Replies View Related

Analysis Services 2005 Database Processing Fails When Run From Integration Services

Oct 11, 2007

Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:

"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"

The cube name is not specific, it will fail and any of my cubes could be in the error log

If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.

I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.

When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.

I've done the following with no effect.

" Have run via AS and works fine
" No specific cube it fails on
" Have created a Dimension only package, same problem
" Changed the maxmemorylimit
" Changed the connections to localhost
" Memory DOES NOT max out on server

Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file

SQL Server 2005 + Service Pack 2

Can anyone help?


View 2 Replies View Related

Unable To Execute Job Inside Sproc From Reporting Services

Mar 21, 2008

We have a request to build a report based on user input from an excel spreadsheet. We have a SSIS package that imports the data from Excel. This is run by a sql server agent job. Our stored procedure executes this job and runs this whole process just fine but when we execute the stored procedure from reporting services we get errors. Has anyone done this type of thing before and do you have any working solutions for how to get this reporting methodology to function?


View 4 Replies View Related

How To Setup User Security For Reporting Services Used Inside ASP.NET Web Applications?

Dec 13, 2007

I'm working on a project that requires integration of SQL Server Reporting Services with ASP.NET 3.0 Web Applications.
I'm working on Visual Studio 2005, with SQL Server 2005 on an XP development workstation.
SQL Server, Reporting Services, and IIS are all running on my local machine.

I'm trying to prototype two approaches, one using the Report Viewer control, and the second using the Reporting Services Web Service. I have the two examples setup in projects in Visual Studio.
The sample reports and data sources work fine in Visual Studio. I can access the report using the Reporting Services URL like this: http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fBTT_BDS_DEV%2fCustomers; Report works fine.

My problem is, that when I try and access the report using the Report Viewer inside an ASP.NET page or from the Web Serivce hooked up inside an ASP.NET Page I get a security errors. I have chosen Windows Security for the Datasource, and ASP.NET pages. In the case of the Web Service, I'm passing in my local domain user name as the credentials.

I'm prototyping this on my local workstation, but I need to design this to be used on our corporate Intranet using Windows Security.

My questions are:

1. How do I need to setup users on my local development workstation to get this to work.
2. How should I plan for user security for enterprise deployment, i.e. using Reporting Services inside a large ASP.NET Web Application?
3. Can anybody give me some links to some good developer type working examples of doing this. I've looked but have not found the answers
to the "how do I setup users" part of the question specifcally related to ASP.NET apps?

Below is the code example of the Web Services example app I'm working with which came out of a book I have on
Reporting Services. This example compiles and seems like it would work but doesn't. Also following are a few of the
error messages I get when experimenting with the example apps:


1. The permissions granted to user 'LocalMachineNameASPNET' are insufficient for performing this operation. (rsAccessDenied)

2. System.Web.Services.Protocols.SoapException was unhandled by user code
Message="System.Web.Services.Protocols.SoapException: The permissions granted to user 'LocalMachineName\ASPNET' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'WCRBUSCNC2830B\ASPNET' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)"
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at WebReportTester.localhost.ReportExecutionService.LoadReport(String Report, String HistoryID) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterWeb ReferenceslocalhostReference.cs:line 242
at WebReportTester._Default.btnExecuteReport_Click(Object sender, EventArgs e) in C:Documents and SettingsconbcxMy DocumentsVisual Studio 2005ProjectsBTT_BDS_DEVWebReportTesterDefault.aspx.cs:line 82
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Web Service Code Example:

protected void btnExecuteReport_Click(object sender, EventArgs e)
byte[] report;

//Create an instance of the Reporting Services Web Reference
localhost.ReportExecutionService rsv = new localhost.ReportExecutionService();

//Create the credentials that will be used when accessing Reporting Services
//This must be a logon that has rights to the Customers Report
rsv.Credentials = System.Net.CredentialCache.DefaultCredentials;
rsv.PreAuthenticate = true;

//The Reporting Services virtual path to the report.
string reportPath = @"/ReportFolder/Customers";

//The rendering format for the report
string reportFormat = "HTML4.0";

//The devInfo string tells the report viewer how to display with the report
StringBuilder deviceInfoBuilder = new StringBuilder();

string deviceInfo = deviceInfoBuilder.ToString();

//Create an array of the values for the report parameters
localhost.ParameterValue[] parameters = new localhost.ParameterValue[1];
localhost.ParameterValue parameterValue = new localhost.ParameterValue();
parameterValue.Name = "@WTRKCustomerCode";
parameterValue.Value = "B34186";
parameters[0] = parameterValue;

//Create variables for the remainder of the parameters
string historyId = string.Empty;
string credentials = string.Empty;
string showHideToggle = string.Empty;
string extension = string.Empty;
string mimeType = string.Empty;
string encoding = string.Empty;
localhost.Warning[] warnings;
localhost.ParameterValue[] reportHistoryParameters;
string[] streamIds;

localhost.ExecutionInfo execInfo = new WebReportTester.localhost.ExecutionInfo();
localhost.ExecutionHeader execHeader = new WebReportTester.localhost.ExecutionHeader();
rsv.ExecutionHeaderValue = execHeader;

execInfo = rsv.LoadReport(reportPath, null);
rsv.SetExecutionParameters(parameters, "en-us");

//Execute the Report
report = rsv.Render(reportFormat, deviceInfo, out extension, out mimeType, out encoding, out warnings, out streamIds);

//Flush the pending response

//Set the HTTP Headers for a PDF response.
HttpContext.Current.Response.ContentType = "text/html";

//Filename is the default filename displayed
//if the user does a save as.
HttpContext.Current.Response.AppendHeader("Content-Disposition", "Customers.htm");

//Send the byte array containing the report as a binary response.

catch (Exception ex)
if(ex.Message != "Thread was being aborted.")
HttpContext.Current.Response.ContentType = "text/html";

StringBuilder errorMessageBuilder = new StringBuilder();

string errorMessage = errorMessageBuilder.ToString();




Any direction here related to best practices on setting up users for code use with
ASP.NET applications would be greatly appreciated...

Thanks in advance...

View 8 Replies View Related

Reporting Services :: SSRS - Nested IIF Inside Switch Not Working

Nov 20, 2015

Here I am trying to do switch then nested IIF in it. I dont know where i missed but this doesnt work.for first condition in switch, 'WEEKLY', WW2 and WW1 is in number form but of text/string datatype. so after cast them to integer/number datatype then those are use in iff operation.for second condition in switch, 'MONTHLY', WW2 and WW1 is month name. so the objective is to get month number from month name. After that, then WW1,WW2 are use in iff operation.

= "WEEKLY", IIF((cInt(Parameters!WW2.Value) - cInt(Parameters!WW1.Value)) > 10, Parameters!WW1.Value,IIF(cInt(Parameters!WW2.Value) < 11,1,cInt(Parameters!WW2.Value) - 10)), Parameters!date_range_type.Value = "MONTHLY", IIF((cInt(MONTH(datepart("YYYY",today())&
"-" & Parameters!WW2.Value & "-01")) - cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW1.Value & "-01"))) > 10, MONTH(datepart("YYYY",today())& "-" &
Parameters!WW1.Value & "-01"),IIF(cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value & "-01")) < 11,1,cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value
& "-01")) - 10)) )

if i run report for 'WEEKLY' only, means doesnt need switch and the other iif condition, it working fine. so does when run on 'MONTHLY' only.

View 2 Replies View Related

DTSX Package Calling Another DTSX Package Question

Jun 13, 2007

I have a dtsx package that is calling another dtsx package, however, if the called upon dtsx package fails with errors or what not, then the calling package does not continue as well. Is there any way to override this such that if the called upon package fails, the downstream actions in that package can stop, but the calling packages downstream actions to continue?

View 3 Replies View Related

Back-up Catalogs

Mar 22, 2001

As backups are done on SQL, it keeps all the catalogs. Over time, there are too many. Which system table(s) contains those backup catalog entries and should
I clean up some of those entries to keep the size in check or there is a max
limit and being taken care by itself.

Appeciate your help !


View 2 Replies View Related

About Database Catalogs

Feb 22, 2008

Hi all,
I am a graduate assistant in Central Michigan University. Currently, My work is to create a table or a catalog that explains all the details of a table and the fields with in the table. We are the looking for details like, stored procedures or Views or other tables or Reports that are using the particular field or table. How can i capture those details and make it as an automated process, which updates when ever there is an add on in use or something else.

Please help me with this as soon as possible.


Swaroop Govula

View 3 Replies View Related

Reporting Services :: Increase Range Bar Chart Size Dynamically Inside A Table In SSRS

Oct 21, 2015

 I have a range bar chart Inside a table of row group and the chart is repeatedly generate according to category ,i want to increase chart height dynamically based on category.

suppose for if category =A THEN CHART HEIGHT=10CM

View 5 Replies View Related

Do GetDate() Inside SQL Server OR Do System.DateTime.Now Inside Application ?

Sep 12, 2007

For inserting current date and time into the database, is it more efficient and performant and faster to do getDate() inside SQL Server and insert the value
to do System.DateTime.Now in the application and then insert it in the table?
I figure even small differences would be magnified if there is moderate traffic, so every little bit helps.

View 9 Replies View Related

FT Indexing One Table ==&> Two Catalogs! POSSIBLE?

Feb 4, 2008

I have currently one SQL FT catalog which indices couple of tables in on our server on nightly basis. It does a 'full' indexing of data as originally designed. Now the time it is taking to index all the data is unacceptable to user. I am working on it to make it index 'incrementally'.

But, for a short-term approach I want to find out, can we FT index a 'table A' in two catalogs on same SQL Server?

View 1 Replies View Related

Updates To System Catalogs

Jul 26, 2007

How to allow updates system catalogs in SQL Server 2005 ?

View 1 Replies View Related

Full-Text Catalogs, Where To Locate?

Dec 8, 2004

Hi All,

looking for some views about where to place these catalogs. The manual says they work more effiecntly on a different drive to the database, which is understandable.

I'm in the processes of designing a new database application which is to be avaiable via the internet, and extranet app. But as I'm planning to host the app and the main database on a shared server but to have the catalogs on another server held in house. The app will have search facilities as its main use. They will obviously be some performace issues, but is this a good idea?

Thanks for any comments..


View 1 Replies View Related

Is It Possible To Replicate Full-text Catalogs

Mar 16, 2004

Replication: Is it possible to replicate Full-text catalogs between servers?

thanks in advance

View 1 Replies View Related

Full Text Catalogs And Permission

Jun 25, 2007


When I create a full text catalog via sql code, does the account the sql server is running under need any special permissions, since some files are created?

Or is it just the same as running any other sql code?


View 1 Replies View Related

Ad Hoc Updates To System Catalogs Are Not Allowed.

Sep 16, 2005

in SQLServer2005 how can I allow update system catalogs (by mouseclick)?

View 59 Replies View Related

Integration Services Notification Services

Apr 18, 2007

Does anybody know of a notification services using SSIS? Is it SendMail or otherwise? Is there a step-by-step practice on how to create one?

View 19 Replies View Related


Nov 16, 2007

I'm trying to execute a stored procedure within the case clause of select statement.
The stored procedure returns a table, and is pretty big and complex, and I don't particularly want to copy the whole thing over to work here. I'm looking for something more elegant.

@val1 and @val2 are passed in


INSERT INTO #TEMP (myint, mybool)
SELECT my_int_from_tbl,
CASE WHEN @val1 IN (SELECT val1 FROM (EXEC dbo.my_stored_procedure my_int_from_tbl, my_param)) THEN 1 ELSE 0
FROM dbo.tbl
WHERE tbl.val2 = @val2


If I have to, I can do a while loop and populate another temp table for every "my_int_from_tbl," but I don't really know the syntax for that.

Any suggestions?

View 8 Replies View Related

Copyrights 2005-15, All rights reserved