[SQL 2012] SSIS dtutil deployment 32 vs 64 bit |
- SSIS dtutil deployment 32 vs 64 bit
- Which version of SQL 2012
- Can't execute SSIS package from remote machine
- Start/Stop/Restart options are desabled on SQL 2012 in SSMS
- Best way to import fixed length ASCII text files, that are not delimited ?
- Smart Input on Web Input Field
| SSIS dtutil deployment 32 vs 64 bit Posted: 14 Aug 2013 02:56 AM PDT SSIS dtutil 32 vs 64 bitI am just not getting the concept. I have a vb.net program that issues the following dtutil statement to deploy a package. I have only tested it on SQL 2008 R2 and SQL 2005 both 32 bit. But according to http://msdn.microsoft.com/en-us/library/ms162820(v=sql.105) a 64 bit install can installl a 64 bit version and a 32 bit version of dtutil and the command prompt will use the 32 bit versionn.Why would I care which bit version of dtutil is called to deploy a package???dtutil /DestS %SSISSERVER% /FILE %FILENAME% /COPY SQL;/%PACKAGENAME% /QUIET |
| Posted: 14 Aug 2013 01:17 AM PDT How can I tell which version that I have of SQL 2012? I need to reinstall the Data Tools becuase the VS 2010 Shell keeps crashing on launch. But I have two 2012 disc - Standard and Enterprise. This is the About page. Microsoft SQL Server Management Studio 11.0.2100.60Microsoft Analysis Services Client Tools 11.0.2100.60Microsoft Data Access Components (MDAC) 6.0.6002.18005Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 7.0.6002.18005Microsoft .NET Framework 4.0.30319.1008Operating System 6.0.6002 |
| Can't execute SSIS package from remote machine Posted: 18 Mar 2013 09:26 PM PDT OS: Windows 2012, standard, 64-bitSQL: 2012 + SP1 + CU2 = 11.0.3339We recently decided to "break apart" our BI environment. We used to have everything on one box, DB Engine, SSIS, SSAS & SSRS. Everything has been running fine, but we now have other projects using these services, so we decided to break them apart into their own boxes.We now have DB Engine on one Server, SSIS & SSRS on another server and SSAS on yet another server, so we now have three boxes that replaced one box. All are Windows 2012, standard, 64-bit with SQL Server 2012 + SP1 + CU2.Since some of our SSIS packages have to access external resources, we used a domain account for it's service account. The DB Engine and SSAS box are using the default service accounts when installed. I can execute the packages fine on the SSIS server, I can even execute them via SQL Agent jobs on the SSIS box (we did install a default instance of SQL on the SSIS box), however when I try to execute a package from my laptop, it fails with the ugly "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I immediately double checked my SPNs and they all looked correct for the SSIS server and the service account we are using (and we had no duplicates). I also double checked the User Rights Assignment in the Local policy editor and all the correct Rights have been assigned (Log on as a service, Bypass traverse checking, Impersonate a client after authentication). I'm stumped here. Anybody have anything else I can check or that I have overlooked?Thanks-A. |
| Start/Stop/Restart options are desabled on SQL 2012 in SSMS Posted: 14 Aug 2013 12:04 AM PDT Hi,I just realize that Start/Stop/Restart options are desabled on SQL 2012 in SSMS. Is there a way to enabled them?Thanks,Rem |
| Best way to import fixed length ASCII text files, that are not delimited ? Posted: 13 Aug 2013 10:35 PM PDT I have my output table setup in my SQL DB, and have tried the SSIS import feature, but i cant get it to work correctly!Importing the text file into Excel, then importing into SQL gives me an ACE error, even after downloading the compatibility package. Save as .csv, then changing it to .txt works, but the output table has some data overlap.I know you can manually set the input lengths in Excel, but it seems like a very long way to do something when i already have the table structure defined!Is there an easier way to do this ? I am using sql 2012 and Excel 2013. Thanks |
| Smart Input on Web Input Field Posted: 13 Aug 2013 01:19 PM PDT I have an input field on a website in which a user enters the City for a particular State in the United States. what I am trying to achieve is smart input for this field. A good example is Startbucks.com , Store Locator input field, where a user enters the beginning text and the possible choices display as smart input. the more text that is entered narrows the possible choices and the entry highlighted and clicked becomes the 'entry'. Would anyone have an idea on how to implement this smart input effect? thxf |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment