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/when-i-create-a-connection-to-the-datasource-of-an-old-application-throw-me-an (SELECT @@VERSION = Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ) After a search in google I found some workarounds with a similar problem: http://n8v.enteuxis.org/2009/12/getting-microsoft-visual-studio-2005-to-talk-to-microsoft-sql-server-2008/ http://support.microsoft.com/kb/954961/en-us But two solutions send me to download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support. I can't install that, because I don't have Visual Studio 2005 and I need "VS2013 - Olds (2000)". I have installed SQL Server 2008 (which I don't use today) and **SQL Server 2012**. Don't exist a 'Microsoft Visual Studio 2013 Update for Microsoft SQL Server Olds'. What can I do?

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 running Visual Studio 2012 and the database has been created using Microsoft SQL Server and localdb. However i wish to run my application on any computer and this current setup will not allow me to do so. I am a bit of a novice when it comes to databases, and would like some advice/resources that outline how i can change my database setup so that it is available on any computer and also retain the data currently in my database. Any help would be greatly appreciated, Thanks in advance!

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 no editor window loads. It's just an empty window like you closed all documents. The Solution Explorer shows items, but notably "ScriptComponent" is an empty folder: If I try to open any of the files (BufferWrapper.cs, ComponentWrapper.cs, main.cs) in the Solution Explorer, I get a popup error box saying: Anyone have any clue what's going on here? FWIW, I have tried closing all instances of Visual Studio and reopening my solution with the SSIS package. The same behavior persists.

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 those lines, but the default behavior seems significantly lacking in my mind. I've dug through a number of options, but nothing seems to impact the display of _only_ the disabled elements. Here's an example image where 4 of the 6 elements are disabled: As much as I'd love to fall back to consistent SSIS development practices, these packages are mainly inherited, so I'm stuck with a mixed bag of approaches to work with. This screenshot was taken from within Visual Studio 2012, but I believe the issue exists on a number of other versions as well.

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 occur." However when I use the exact same deployment profile and publish from Visual Studio 2012 it goes through.

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 a script within the project please help team

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 the excel...even though they are blank e.g I only have 300 + rows of data at the moment, but it loading every row even though they are blank e.g going pass the 400 row where there is no data yet I don't want it reading 200,000+ rows before it actually loads the 300 how do I stop this please team

I have sql project in visual studio and I created pre-deployment script /* Pre-Deployment Script Template -------------------------------------------------------------------------------------- This file contains SQL statements that will be executed before the build script. Use SQLCMD syntax to include a file in the pre-deployment script. Example: :r .\myfile.sql Use SQLCMD syntax to reference a variable in the pre-deployment script. Example: :setvar TableName MyTable SELECT * FROM [$(TableName)] -------------------------------------------------------------------------------------- */ :setvar TableName MyTable SELECT * FROM [$(TableName)] but Iam getting an error at :setvar line Incorrect syntax near ':'. what am I missing ?

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 development machine or on the server hosting the SQL Server instance. How can I obtain this file, so I can get rid of warnings like the following: SQL71502: Procedure: has an unresolved reference to object [sys].[objects]

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 package for each databaseview in two defines databaseschemas. For example: - [crm].[contact] - [crm].[account] - [navision].[vendor] - [navision].[customer] The name of the packages will be [schemaname] viewname, e.a. "[crm] contact". When I start a package in Visual Studio I get the message "Failed to start project" see below. "Exception deserializing the package. "Specified part does not exist in the package". Why is this error occurring?

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 file, getCSV.dtsx, and another to Load said csv file into our Oracle tables, loadData.dtsx. Now that they are working independently, I have started to put them together in one 'main' package getandLoad_AllTables.dtsx consisting of a sequence container for each table, 2 packages per container; getData/loadData using 'Execute Package Tasks' to call these packages from the local file system in the order I have laid out in my control flow. The issue - both the tasks are called, run and completed within the first container however the getandLoad_AllTables package errors out, detailing that Error: 0xC001000E at loadData: The connection "{long-ass string}" is not found" I checked the ID of the connection in the XML of loadData.dtsx and found it is the main connection used within all the 'Execute SQL Tasks' in the loadData package, all of which ran successfully and loaded the data into the tables as expected. Why is this error thrown in the getandLoad_AllTables package and not in the loadData package it says the connection is missing from? I am completely stumped. Thank you in advance for any help/guidance/advice anyone can give.

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 it with other datatypes such as nvarchar and it works when I pass multiple selected values to 1 stored procedure parameter and return the select statement using dynamic sql to populate my gridview. Ps. In my webserver i'm displaying in checkboxlist as e.g 31-Aug-2013, using DATE.DataTextFormatString = "{0:dd-MMM-yyyy}";. In my sql database, it is displayed as e.g 2013-08-31. During debugging selectedDATE do read it as e.g 2013-08-31. however there is error at da.Fill(ds); line ASPX.CS protected void Page_Load(object sender, EventArgs e) { DATE.DataTextFormatString = "{0:dd-MMM-yyyy}"; using (SqlConnection conn = new SqlConnection(dbConn)) { try //Call stored procedure { SqlCommand cmd = new SqlCommand(spddl, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (!IsPostBack) { DATE.DataSource = ds.Tables; DATE.DataTextField = ds.Tables.Columns["DATE"].ToString(); DATE.DataBind(); } if (IsPostBack) { Bind(); } } catch (Exception i) { bool exception = true; if (exception == true) { //txtMessage.Text += e.Message; } } } } public void Bind() { using (SqlConnection conn = new SqlConnection(dbConn)) { using (SqlCommand cmd = new SqlCommand(spretrieve, conn)) { String selectedDATE = String.Empty; if (DATE.SelectedValue == "All") { selectedDATE = "DATE"; } else { foreach (ListItem item in DATE.Items) { if (item.Selected) { DateTime dtTemp = Convert.ToDateTime(item.Value); selectedDATE += "'" + dtTemp.ToString("yyyy-MM-dd") + "',"; } } selectedDATE = selectedDATE.Substring(0, selectedDATE.Length - 1); } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@param", SqlDbType.DateTime).Value = selectedDATE; conn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds= new DataSet(); da.Fill(ds); GRIDVIEW.DataSource = ds.Tables; GRIDVIEW.DataBind(); } } SQL ALTER PROCEDURE [dbo].[SP] @param nvarchar(512) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @sql nvarchar(max) SET @sql = 'SELECT * FROM TABLENAME WHERE [COLUMN] IN (' + @param + ')' EXEC sp_executesql @sql; END

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 were a few answers. One solution they say was running a C# script. Here is it . But I don't know how to run, and anyway if that script will work or not. Thanks for help.

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 Server 2012 prompts me for the **ms_setup.msi** installation file from Visual Studio **2010**. However, I am using Visual Studio **2012** currently only. The equivalent file in VS 2012 is called vs_professionalcore.msi and is located in Visual_Studio2012_Pro\packages\professionalcore\Setup\. **How can I install SQL Server 2012 with Data Tools having only Visual Studio 2012 given the setup?** Is there a download or registry entry I need to make? Thanks for any pointers.

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 configure my Instance Name like this picture : When I deploy my project I have This picture : But after one minute I get this error : And when I click on Details Of Error I get this message : OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server . ; 08001. A connection could not be made to the data source with the DataSourceID of 'a16b8d9d-3811-4be1-91e7-a9d0a2df4d38', Name of 'SqlServer localhost'. And But it not work for me??? In my SSAS one Database was created like this picture :

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 level, which means it checks for the table if the table is not available in the destination, it creates. But my problem is: In the old database in a specific table I have a Name column with NVARCHAR(50) mean while in the new database table I have same Name column with NVARCHAR(100) datatype. Now I want to ignore this column level comparison only for this specific table field. Visual Studio allows me to do this at the table level only, not at the column level. Can anyone tell me how it would be possible?

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 also having data for that input but still i am getting error that no matching records found. > **example for my schemario:** i have a view that fetches data like > orderby, orderno, orderdate. **orderby is a usercuid nchar(64)**. i have a > Dim in Dw named DimUser which is having usercuid. and i have to get > DimUserId for matching usercuid. in my input data i am getting > **orderby as "User1"** and in my DimUser there is record with > **usercuid=User1** but **still ETL is failing with no matching records**... anybody could suggest how could i find out what is the problem?

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 view, and probably never will. I just prefer the text editor. Is there a way to tell VS to default to the T-SQL view?

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 used the VS2012 publish command with "Window Authentication". The SQL Server is on a different server than the Web Server. I have set up and given the correct permissions to the Application pool for both the NTFS and SQL Server (remember my SQL Server is on a different (virtual) Server. I used this document to set up the particulars: IIS Setup Win2008R2 Server With IIS 7.0 I also added the machine name (Domain\MachineName$) as a user to the SQL Server, as I couldn't find a way to add the app pool as a user to a SQL Server that wasn't on the same box. Bonus Question -- Is there a way to get the app pool from one server recognized on a different server... it actually came up in intellisense in SQL Server Management Studio, but I wasn't able to add it? Everything works for "My" login (which is a member of the "administrator" group), but I was unable to allow users to get access to the intranet website unless I added their username to the root folder of the website and gave them permissions. **My Questions:** (Bearing in mind that this is an intranet app that will only be accessed by authenticated users) 1) Is it OK from a security standpoint to grant users access to the root of the website? If not ... what am I missing... If this is a no-go from a security standpoint, what are the better ways to do this? If it is OK, what permissions do they need? Bonus Question: 2) Is there a way to get the app pool from one server recognized on a different server?

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 Oracle Connection Manager by Attunity 2.0 I had this working, then renamed and deleted some files, and tried to build it again when I ran into this problem. When running Source Assistant, I receive the Visual Studio Error: > The component could not be added to the Data Flow task. Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. There is an "Additional Information" section that references: > Error at TERM [SSIS.Pipeline]: Component ", clsid {4CAC6073-BCA7-430E-BD29-68A9F0012C6D}" could not be created and returned error code 0x80070005 "Access is denied.", Make sure that the component is registered correctly. > >Error at TERM [ ]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this copmonent is "". Note: "TERM" is the name of the Data Flow task (named after the table I want to copy with SSIS. This clearly looks like registry damage to me, so I had uninstalled the Attunity copmnent and re-installed it; and I ran a repair on Visual Studio 2012 (in that order); rebooted, etc. No luck so far. Anyone ever seen this before and/or have any ideas how to get back to a working SSIS development? I am working on a development box, my Oracle Connection tests fine, and I can also connect fine to my SQL Server 2012 instance as well.