Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.
Questions tagged [sql-server-2012-datatools]
84 questions
0
votes
2 answers
Issue while using the temp table in the SP with SSIS 2014
I have a SSIS 2014 package where I am using a SP. That SP is creating the temp table and inserting data into that temp table and returning the result set. When I use the package with SQL SERVER 2005 then it is working fine but when I use the SQL…

Pankaj Saha
- 869
- 3
- 17
- 37
0
votes
1 answer
No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found
I migrated a schema of DB2 v9.1.700.855 to SQL Server 2012 using the tool "SSMA (Microsoft SQL server migration Assistant) for DB2", I can establish a connection, but it shows an error :"Error occurred while collecting data". I checked the log file…

Lucas Carvalho
- 48
- 1
- 6
0
votes
1 answer
Add a Scroll box in SSRS
I've searched the all Internet and didn't come up with a solution.
well, I have a report for a client which I made it in ssrs.
The report basically display :
Col1 Col2
Num Num
I want to add a Col3 with a scroll box that the client (user) will…

Jordan1200
- 478
- 1
- 5
- 20
0
votes
1 answer
VB - Fill cell background based on date comparing today to cell value
I have a column that returns dates in this form:
"2016-06-01 23:29:34.283"
I am wondering how I can fill the cell background green if the day matches today, and red if its not today (hour and minute doesn't matter).
I tried this but no luck:…

choloboy
- 35
- 1
- 7
0
votes
1 answer
How to Overwrite Database Table Data Using SQL Server Data Tools
I'm currently working on a small project using sql data tools. I'm getting data from excel sheet and write it back to my database table. from the database table I'm generating a report. Time to time I'm updating my excel sheet. but it won't update…

shona92
- 63
- 1
- 12
0
votes
1 answer
How do I separate query results into columns where data from each month is represented?
Every month we bulid widgets. We build red, green, and blue widgets.
How do I write a query that tally's the number of widgets produced of each color by month? I would like the results to be a chart with the y axis labeled Red, Green, Blue and the x…

theteague
- 413
- 4
- 10
0
votes
1 answer
SSIS Google Analytics Issue: "Unable to cast COM object"
I'm using the GA Analytics data source for Data Tools 2012. I'm able to log-in and use the component within an SSIS package, debug and run the package, fetch and load data (to OLE DB target). No problems!
But when I try to deploy the package to…

Eyal Zinder
- 614
- 1
- 8
- 21
0
votes
1 answer
Compare dataset with another dataset for multiple Columns/Values SSRS
This is the image reference. Let me explain the scenario.
There are two datasets A and B as you can see, dataset B has actual tests values and dataset A has target values (more like ranges). code compares each test (BLK ...) value to the target…

cynocyber
- 7
- 5
0
votes
1 answer
Derived column expression only capture 10 characters
I am new to SSIS and I have searched to find the solution to this question. Any help is most appreciated!
I have a flat file with data defined as dt_wstr, to change the datatype I am using a data conversion to set the [column] to dt_str(50)
I am…

Dawana
- 1
- 1
0
votes
1 answer
Roll up not working correctly when using custom key columns
I have a dimension that I flattened, the data looks like:
This is a simplification of the data, I actually have 7 "Detail" values that are the same for each PrimaryValue and 2 "SubDetail" values. Each SubValue has one blank (not a null, there are…

Mrphin
- 185
- 2
- 15
0
votes
0 answers
How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)?
How to insert IDENTITY column when creating table by this method (creating IDENTITY in table level)?
Create Table ProspectiveTenant
(
PTID int,
Name varchar (25),
Email varchar (25),
ApplicationFillDateTime Date,
MetSamanthaDateTime Date
Add (PTID)…

Matt
- 1
- 1
0
votes
2 answers
SSAS Process Dimensions Error
I'm trying to deploy my SSAS project but I keep getting this error that makes no sense to me?
Error 5 Internal error: The operation terminated unsuccessfully. 0 0
Error 6 The datasource, 'Adventure Works DW2012', contains an…

Erik Lydecker
- 719
- 3
- 12
- 29
0
votes
1 answer
Report is not loading
I have created one report with 4 parameters. one of the parameters having greater than 1000 item values.I have following issues
Reporting Services don't show data after selecting parameters
Reporting services displays blank page
Report is…

Alias Varghese
- 2,104
- 3
- 24
- 52
0
votes
1 answer
Dynamic CRM 2015 SSRS connection error
Guys.
I have an error when I tried to connect CRM 2015 online instance from VS2012. I have already installed Data Tool for VS2012 and CRM extension. Then when I create a new report wizard data source at VS2012, I choose MS Dynamic CRM Fetch as Type…

Simeng
- 13
- 1
- 6
0
votes
1 answer
SQL SSAS Cube Deploy Error:
I am trying to deploy a cube I created in SQL Server Data Tool using AdventureWorksDW2008R2, I used windows authentication login the database engine with all permissions granted to it. and yet I still get these arrors in the picture below when…

shadow master
- 72
- 2
- 9