Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-datatools]

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.

84 questions
3
votes
1 answer

SSIS 2012 SP1 "Value of null is not valid for stream" error on designer components

I have just migrated a project from SSIS 2005 to SSIS 2012 Apart from the project, I had a custom pipeline component, which was also migrated to .NET 4.0, and installed in SQL Server DTS directory and the GAC, as usual. After the migration, when I…
JotaBe
  • 38,030
  • 8
  • 98
  • 117
3
votes
1 answer

Limited VS2012 SQL Syntax Highlighting

I have two instances of VS2012 Premium (11.0.51106.01 Update 1) on different machines (both Win8, 64bit). Both have SQL Server Data Tools installed. In both I'm working on a same SQL Server Database Project. But one instance have limited SQL syntax…
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
2
votes
1 answer

How to manage multiple tables, function, stored procedures and views (SQL Server)

I have multiple object in my database and i would like to list them give some description, accepted parameters and their types. The fastest way I know is to generate a database script and call it a day, but is there an easier way to archive this? I…
shanji97
  • 71
  • 1
  • 7
  • 19
2
votes
1 answer

SSRS - How to add a default value to a parameter with Available Values from a query?

I have an SSRS report which contains a parameter ID, which will display sales totals for a person with selected ID. I get the options for the parameter by selecting "Get values from a query" under the Parameter's "Available Values" setting. However,…
thnkwthprtls
  • 3,287
  • 11
  • 42
  • 63
2
votes
1 answer

ispac not created when SSIS Project built

With a 2012 SSDT database project and a Integration Services project within it using project deployment model, after a build, a .ispac file is not created for me. Is there a setting or option that is necessary to allow this to be created? The…
Jason R.
  • 379
  • 1
  • 6
  • 19
2
votes
1 answer

How to Take Error Exit Path on Data Flow Task in SSIS Data Tools

I'm downloading CSV files using FTP and I loop through them to import into a MS SQL staging table. What I want to do is move successfully imported files into an archive folder and move failed files into a failed folder. My problem is that I can't…
Amarundo
  • 2,357
  • 15
  • 50
  • 68
2
votes
1 answer

(SQL Server Analysis Services) MDX query to get immediate parent?

Desired result When a cube is deployed and browsed, I wish to see only an immediate manager of an employee. The cube result shows all managers of a paticular employee, like below: Abbas, Sanchez, 825 Abbas, Welcker, 825 Abbas, Abbas, 825` I…
user4296898
2
votes
1 answer

How to add an extra column to handle error message in a SSIS data flow?

I'm working on a SSIS project in order to import calls rows (Excel file) in a SQL Server database. Here is my data flow : I added some lookups to check rows before import process. The first one checks if the row already exists (made to prevent…
K4timini
  • 711
  • 2
  • 14
  • 34
2
votes
2 answers

Package Validation Error

I'm trying to use a foreach loop container to import several excel files into a table, I specified the folder and the files I'm going to use (*.xls), after that I created a path variable then I went to the excel source connection and in the…
David Acosta
  • 27
  • 1
  • 1
  • 5
2
votes
1 answer

Create Sql Database using xml schema and xml data file

How to create Database in Sql Server using xml schema and xml data file. I tried different things I cant solve the problem. I am using these files XML SCHEMA: http://www.drugbank.ca/docs/drugbank.xsd XML DATA FILE:…
Ahmad Abbasi
  • 1,776
  • 6
  • 29
  • 43
2
votes
0 answers

Issue with Oracle Client Data Source in SQL Server 2012 SSIS

I am having an issue with Oracle connectivity from an SSIS project, and have been Googling around to try to find a solution for over a week, now, and haven't found anything. I have the following configuration in my dev environment: O/S: Windows…
user3306611
  • 21
  • 2
2
votes
0 answers

Unable to Add Refences in SSIS Script Task

Hello, I have a particular problem with SQL Server 2012 SSIS. When I want to add a reference "Script Component", in order to use FileSystemObjects. The Visual Studio IDE simply doesn't add it. I'm doing the following: 1) Open Solution Explorer in…
Overseer10
  • 361
  • 2
  • 9
  • 20
2
votes
1 answer

data cleansing icon not in toolbar

I installed SQL Server 2012 - Enterprise Edition with Data Quality Services. Now, I want to use data quality services, data cleansing task from a package in Integration services. The problem is I can't find the task in the toolbar. Do I have to…
Corovei Andrei
  • 1,646
  • 6
  • 28
  • 42
1
vote
1 answer

Local window shows empty Variables while debugging SSIS package in VS Data tools 2012

This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty. SS of Locals window showing blank value for Variables collection variable Updated after…
dejjub-AIS
  • 1,501
  • 2
  • 24
  • 50
1
vote
0 answers

SSIS programatically update column Names and data type

I have created a script task that reads an excel file and tries to update the connection manager columns' details. BUT even if it runs without errors, the changes are not "saved", so the package maintains the previous details of the columns. After…
gematzab
  • 181
  • 1
  • 3
  • 14
1
2
3 4 5 6