bids Questions
7
Solved
I have a report (BIDS SSRS 2008 R2) that has a parameter that allows the user to select multiple values from a list (Sales Regions, lets say).
I want, though, since the list is long (15 or so pos...
Wrest asked 30/9, 2013 at 20:12
3
Solved
I need a row value in my SSRS report that is a calculated one based on a couple of fields that are already being used in the report. I want it to display in the textbox named 'textboxPercentageValu...
Guyguyana asked 12/1, 2016 at 17:5
3
Solved
I have the following code written into an SSIS Script Task to connect to my SQL database:
ConnectionManager cm;
System.Data.SqlClient.SqlConnection sqlConn;
System.Data.SqlClient.SqlCommand sq...
4
Solved
I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the pa...
Marijn asked 4/8, 2011 at 14:13
3
Solved
I have an SSIS package that includes a Process Task. The process task needs to execute batch file. The location of the batch file varies depending on the environment (dev, production).
How do I dy...
Zulazulch asked 25/7, 2011 at 15:23
3
I am creating an ETL in SSIS in which I which I want my data source to be a restricted query, like select * from table_name where id='Variable'. This variable is what I defined as User created vari...
3
Solved
I have a report part which deployed perfectly every time I made any changes until today.
The report has around 20 links, and an image on it.
I have added a table to it today, clicked deploy and i...
Marcus asked 20/6, 2012 at 10:22
2
Solved
I am working on a SSIS project. I have a Flat File Source (csv) and OLE DB as destination. I have a column named WrapUpName with a data type Unicode string [DT_WSTR] with a Outputcolumnwidth - 50 t...
Brittanybritte asked 20/4, 2017 at 0:54
5
Solved
Environment
DB Server (DWH prod & dev + SSRS prod)
Win XP SP3
SQL Server 2008 Ent
Corporate LAN
No remote query timeout restrictions for DWH, i.e. they are set to 0
600 seconds for remote ...
Inject asked 15/10, 2012 at 6:0
6
Solved
How can I access variables inside my C# code which I've used in Data Flow -> Script Component - > My c# Script with my SSIS package?
I have tried with which is also not working
IDTSVariables100 v...
6
Solved
My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image)
I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get...
3
I am building an SSRS 2005 report using BIDS. My report filters on date. When the selected date returns no data rows the report is blank, just the title is displayed, no table or column heading.
H...
Blase asked 13/4, 2012 at 19:15
4
I have a reporting solution with several reports. Up to now, I have been able to add a dataset based on a SPROC with no problems. However, when I try to add the lastest dataset, and use a SPROC for...
Midday asked 21/8, 2012 at 9:36
2
Solved
I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has driven me nuts because I don't know how to separate the statements:
@[Use...
Garlen asked 12/6, 2015 at 16:41
2
Solved
I am working on a DWH application. The server I was granted access to only has SSIS installed with no database engine. I am getting errors like:
The EXECUTE permission was denied on the object '...
Lueck asked 24/2, 2017 at 11:41
1
Solved
I have been using Visual Studio 2010 for Reporting Services projects, with a SQL server 2012 reporting services back-end. To display the report we went from version 10,to 11 with the Reporting view...
Fremantle asked 26/7, 2016 at 20:48
4
Solved
I have built a cube in Business Development Intelligent Studio(BIDS) using some database with the name 'Test_cube' which consists of Products dimension table, customers dimension table and orders f...
4
Solved
Does anyone know if/when the BIDS add-on will be available for VS2015? It's the only thing holding us back from migrating. Or is there different method for building SSRS reports in VS2015?
Update:...
Clementia asked 21/7, 2015 at 22:48
2
We recently upgraded from SSRS 2008 R2 to SSRS 2012. A good portion of our existing reports are now rendering with some columns cutting off right-aligned text.
We used BIDS 2008 to develop the rep...
Intrinsic asked 14/1, 2014 at 14:36
3
Solved
I want to use SSIS /BIDS project in Visual Studio 2012.
I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL
Server 2012.
VS 2010 was installed first follow...
Degradable asked 4/1, 2013 at 18:41
7
Solved
I have SQL Server 2012, SSIS, SSDT and Visual Studio 2010. I can create a new SSIS package and add a Script Task, but if I attempt to open the Script Editor for that Script Task I get the following...
Dithyrambic asked 3/5, 2012 at 14:46
5
I have installed Microsoft SQL Server 2005.
This consists of the configuration tools (SQL server configuration manager, SQL Error and usage Reporting, SQL Server Surface area configuration, Report...
Insatiate asked 19/7, 2009 at 16:4
6
I would like to keep a task in an SSIS package but enable/disable it when i please. Is there a way to do this?
Is this big business?
Lesialesion asked 28/12, 2010 at 17:58
6
Solved
I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs have worked fine (mostly) for years and although I've had a few hiccups tha...
Hege asked 17/10, 2012 at 13:30
5
Solved
I'm newly getting into creating and programming reports using SQL Server Reporting Services.
One thing that bugs me right off the bat: I can't seem to find an easy way to tell the BIDS (Business ...
Tronna asked 11/11, 2009 at 13:49
1 Next >
© 2022 - 2024 — McMap. All rights reserved.