- Blind-sysadmins - lists.hodgsonfamily.org

import csv files
by Marvin Hunkin 22 Jul '15

22 Jul '15

Hi andrew and all. I have got the tables set up. But I need to import and did try Microsoft access, but got no where, and need to import csv files. So, how do I fix those issues, and th 32 bit said I needed to do a connection string, and do I need to save the syrus or sirus data files. So which check boxes to check, did check one. But so, how to fix. Or is there a tsql command to import into sql server. Totally frustrated. Marvin. Ps: have got the tables set up, and did try importing data, and used the flat file in the express, but said I needed the pro, or developer. So got the developer to save the imported data. So, help me out. Totally frustrated, which check boxes do I need to check, did check it,a nd no other check boxes. Totally frustrated. Marvin. Ps: tried ms access 2010, but it did not like the ms access jet engine or the format, did save it as .mdb for 2003 / 2002. So help?

2 2

cannot import csv files into sql server 2014 developer help!
by Marvin Hunkin 22 Jul '15

22 Jul '15

hi. trying to import a table into sql server developer 2014. went with the 64 bit import and export wizard, as the 32 bit would not let me set a connection string. and my lectuer said to create a access database, so i imported the tables, set it up. and did save it as .mdb. but when i tried to import into sql management studio, says the format is unreconginizeable. have got the two tables, schemr set up in sql management studio. can any one help me, is there an easier way or more accessible screen reader tools to allow me to import .csv files into sql management studio. will paste the errors below. can any one help. totally frustrated. marvin. ps: either i am doing some thing wrong or stupid, or it is not liking it for some reason. frustrated. tried googling the errors, but could not seem to find an answer. frustrated! need this for an assignment. not to do it for me, but a solution to help me out. marvin. ps:: the results screen, cannot seem to click on the links, with my screen reader, and when i try, it does not go to that, so totally frustrated and getting annoyed. will paste below. Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error) Messages Error 0xc020201b: Data Flow Task 1: The number of input columns for Destination - StockPrices.Inputs[Destination Input] cannot be zero. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task 1: "Destination - StockPrices" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard) Error 0xc004700c: Data Flow Task 1: One or more component failed validation. (SQL Server Import and Export Wizard) Error 0xc0024107: Data Flow Task 1: There were errors during task validation. (SQL Server Import and Export Wizard) - Prepare for Execute (Stopped) - Pre-execute (Stopped) - Executing (Success) - Copying to [dbo].[StockPrices] (Stopped) - Copying to [dbo].[OrderDetails] (Stopped) - Post-execute (Stopped)

2 2

the rtm version visual studio 2015
by Marvin Hunkin 21 Jul '15

21 Jul '15

Hi. Has any one downloaded the official release rtm final version visual studio 2015, and downloaded the videos and audio for such topics, as useability, testing, accessibility, asp and azure, and the cloud and the keynote. So. Will go to the visual studio download site, and also see if dream spark, has the new versions up. Marvin.

1 0

is there a exe file for the adventure works
by Marvin Hunkin 21 Jul '15

21 Jul '15

Hi. Tried to attatch the adventure works 2012 and 2014. Is there an exe file, cannot attach. Tried a few .mdf files, and not attatching. And if I create a database, cannot attatch. What am I doing wrong? Thanks.

2 2

Re: [Blind-sysadmins] Anyone played with Microsoft Service Management Automation?
by Christopher McMillan 20 Jul '15

20 Jul '15

Dear Ryan: This is very exciting news. Never even mentioned at the WPC15 this past week in Orlando, FL. I would love to learn more about your success or failures. Microsoft Server core needs to discuss this in more detail. SCO is a royal pain to use and I am finding it more difficult on Win Server 2016. So any insight would be very helpful Christopher McMillan MSparter on Accessibility Sent from Windows Mail From: Ryan Shugart Sent: ‎Sunday‎, ‎July‎ ‎19‎, ‎2015 ‎4‎:‎40‎ ‎PM To: Blind System Admins Hi: I was wondering if anyone here has started playing with Microsoft Service Management Automation? I was told about this product last week by one of our consultants who claimed that in the future this would be the replacement for System Center Orchestrator, and does much the same thing as that product does now. Unlike SCO, however, SMA has no GUI whatsoever accept for a small web front end to do some basic workflow management. Everything else is supposedly managed 100% through Powershell, so accessibility wise this might be a boon for us. I’m going to try and set up some test servers next week and start messing with it, but was wondering if anyone has beaten me to it and knew how hard it was to get going? Ryan _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins(a)lists.hodgsonfamily.org https://lists.hodgsonfamily.org/listinfo/blind-sysadmins

2 1

using a entity diagram visual studio 2013
by Marvin Hunkin 20 Jul '15

20 Jul '15

Hi. Has any one worked with the entity designer, doing a database assignment, and need to do a entity diagram, relationships from the tables, and the collumns. Using jaws 16, windows 8.1 64 bit enterprise, and also using visual studio 2013 community edition. Any ideas. Thanks. Marvin.

2 2

levtech winstaller
by Marvin Hunkin 20 Jul '15

20 Jul '15

Hi. Staying clear of that as well. Okay, got sql server 2014 developer working, created my database, via the create database script, as the file wizard kept saying empty file name, and then created my two tables, then set it up, then entered the data. All is working fine now. Just have to add the adventure 2014 works database, samples, and then good to go, next part of my database assignment. Creating a new table, importing data from a .csv file. Then run the script, then save the table data. This was not doing that under express. Okay, with the windows talking pe, can I use a usb stick, got a 4 gb and a 30 gb, if I need to reinstall windows 8.1, or update to windows 10. Marvin.

1 0

Worth getting Levtec Winstaller question
by Christian 20 Jul '15

20 Jul '15

Hi all, The subject says it all, is it worth purchasing this package? I have been using the free Talking WinPE and I am able to install Windows with that, but are there any advantages with that other package? Many thanks, Christian

8 19

Anyone played with Microsoft Service Management Automation?
by Ryan Shugart 19 Jul '15

19 Jul '15

Hi: I was wondering if anyone here has started playing with Microsoft Service Management Automation? I was told about this product last week by one of our consultants who claimed that in the future this would be the replacement for System Center Orchestrator, and does much the same thing as that product does now. Unlike SCO, however, SMA has no GUI whatsoever accept for a small web front end to do some basic workflow management. Everything else is supposedly managed 100% through Powershell, so accessibility wise this might be a boon for us. I’m going to try and set up some test servers next week and start messing with it, but was wondering if anyone has beaten me to it and knew how hard it was to get going? Ryan

1 0

sql server 2014 databaseinstall success
by Marvin Hunkin 19 Jul '15

19 Jul '15

Hi. Was able to install it. And now. Just reading up how to create a new database. Looks like I need to create the database skemer? Is that correct. Everytime, expand the database top node, right click create or new, and enter a name, click add, then ok, gives me an error saying the file name was blank. But it is not empty. How do I create a new database, and now to import a sql or mdf file. Thanks. Ps: maybe missing some thing simple, but was able to create new in express. Needed developer, as the next assignment, is to import data into a new table from a .csv file, and the express, said it did not save the import. Any ideas. Thanks.

1 0