Questions tagged [visual-studio-2012]
The visual-studio-2012 tag has no usage guidance.
23 questions
1
vote
3
answers
3k
views
find table used in SSIS Package script [duplicate]
I have a number of SSIS Packages
I am trying to locate a table that is populated by one of the SSIS Package
is there an easy way to find in the project where database.dbo.tabledata has been used in ...
- 11
0
votes
1
answer
79
views
SSIS AND XLSM load time issue Visual Studio 2010
I am having the following issue of SSIS AND XLSM load time issue Visual Studio 2010
I want to speed this up
I am reading a .xlsm as my excel source
I have noticed its loading / reading every row of ...
- 11
6
votes
1
answer
268
views
Any Tricks to Better Identify Disabled SSIS Elements?
Does anyone have any tricks they care to share that will help better identify disabled elements within SSIS packages? Ideally there's some manner to adjust the text color to red or or something along ...
- 9,497
3
votes
1
answer
2k
views
'Connection not found' error thrown at end of task, after the package has successfully used the connection it refers to as missing
Sorry for the long title and this long question!
I'll set the scene. I'm fairly new to VS and SSIS.
I have created several SSIS packages, basically a package for retrieving data and creating a csv ...
- 41
0
votes
1
answer
2k
views
SQLCMD is not working in pre-deployment script in sql project
I have sql project in visual studio and I created pre-deployment script
/*
Pre-Deployment Script Template
--------------------------------------------------------------------...
- 1,109
0
votes
1
answer
4k
views
ERROR: Failed to convert parameter value from a String to a DateTime
I have faced this error: Failed to convert parameter value from a String to a DateTime when trying to pass multiple selected dates from checkboxlist to my parameter to be used in sql.
I have tried ...
- 1
5
votes
4
answers
17k
views
Script component source won't load when click "Edit Script..."
I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but ...
- 311
1
vote
0
answers
59
views
SQL Server Comparison
I am merging two different versions of a database. I want to add some specific fields from source database to destination, so I used Visual Studio to do that. It does the job quite well but only table ...
- 111
-1
votes
2
answers
849
views
how to identify why lookup failed in SSIS
i have created an ETL package and having a lookup to match userid in db.
i checked in dataviewer what data is going as input to my lookup. the data is correct and the table i used in lookup to match ...
- 323
4
votes
3
answers
24k
views
SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)
I have a sql file, which is up to 180 Mb. When I try to open and execute it on Microsoft SQL Server Managment Studio 2012, I am getting this error.
. What do do ? I researched on Google. And there ...
- 143
1
vote
2
answers
10k
views
SSIS Failed to start project
I've created sereral SSIS packages in Visual Studio 2012 and they can be executed without any problems.
For a project I'm working on I generate packages using BIML. In my BIML script I create a ...
3
votes
2
answers
5k
views
Where can I get the master.dacpac file for SQL Server 2012?
I am using Visual Studio 2012 Professional with SQL Server Data Tools with a SQL Server 2012 standard edition database instance.
I have been unable to locate a master.dacpac file on either my ...
- 2,191
1
vote
1
answer
2k
views
How should I set up SQL Server Login permissions for access to website on a different server using Windows Authentication
I know this question doesn't really belong here, but I posted on the MS IIS Site and am still hoping for a reply. I have an intranet site created with .NET Framework 4.0 in Visual Studio 2012 and I ...
- 205
0
votes
1
answer
4k
views
Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010
I am trying to install SQL Server 2012 Enterprise with SQL Server Data Tools included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL ...
- 101
0
votes
1
answer
3k
views
VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component ", clsid {4CAC ... Could not be created
I am creating my first SSIS package to support the E of our ETL from an external Oracle database to our internal SQL Server 2012 databse.
Using Visual Studio 2012 and I have installed the Microsoft ...
- 203
1
vote
1
answer
611
views
Is it possible to restrict SQL Server DB_Owner when connecting using SQL Server Mgt Studio? [duplicate]
Here is the back story. A developer created an EXE program. The exe program has the ability to access a SQL Servre database. In order to do that we create an Active Directory group. Let's call this ...
- 413
4
votes
1
answer
38k
views
SQL Server is configured to allow remote connections
I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T)
Then I download AdventureWorks Tabular Model SQL Server 2012 From This link
I open it with Visual Studio 2010 and ...
0
votes
1
answer
3k
views
Support to SQL Server 2000 from Visual Studio 2013(SQL Server 2012)?
I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer:
https://stackoverflow.com/questions/21065565/...
3
votes
1
answer
4k
views
VS2012 setup spoils SQL Server 2012 Data Tools for everybody or just me?
On Windows 7 Prof I have installed SQL Server 2012 R2 with, as I am pretty well remember, client tools.
Then, I tried to install Visual Studio 2013 Ultimate but failed.
Then I've installed VS2012 Prof ...
- 1,392
14
votes
3
answers
20k
views
sqlpackage.exe ignoring BlockOnPossibleDataLoss?
I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could ...
- 2,907
2
votes
2
answers
427
views
Can I default to T-SQL only view in VS 2012?
When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design ...
- 121
1
vote
2
answers
4k
views
Microsoft SQL Server how can i detach localdb to run on any computer
I am working on a personal project and have implemented a database system using the Entity Framework code first tutorial on msdn, link below,
http://msdn.microsoft.com/en-gb/data/jj193542
I am ...
- 13
2
votes
0
answers
2k
views
SQL71561 Error on Schema compare after initial import from database
I have created a new sql server project with SSDT 2012, then I went to import an existing database and it created all my scripts. After that I did a schema compare between the project and the database ...
- 2,907