Dtsrun Error 170
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Data Warehousing » Data Transformation Services (DTS) » Syntax Error For DTSRUN Command Syntax Error For DTSRUN Command Rate Topic Display Mode Topic Options Author Message deekdeek Posted Tuesday, February 18, 2003 3:12 PM SSC Journeyman Group: General Forum Members Last Login: Sunday, October 18, 2009 1:41 AM Points: 82, Visits: 19 I'm trying to use a DTSRUN command, and I keep getting a syntax error of "Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '/'."The database is MSDB, and the exact code I'm using is:"dtsrun /SDHSBAYSQL05 /Udsperedelozzi /PMSMSDATA /NFull_Data_Import"There is no password for the DTS job. Can you tell what's wrong with my code? Post #10068 philcartphilcart Posted Tuesday, February 18, 2003 4:39 PM SSCrazy Group: General Forum Members Last Login: Tuesday, October 4, 2016 4:09 PM Points: 2,708, Visits: 1,411 The message you get sort of points to an error with some SQL being used within the package.Can you successfully execute the package via the designer?ThanksPhill Carter Hope this helpsPhill Carter--------------------Colt 45 - the original point and click interface Australian SQL Server User Groups-My profilePhills PhilosophiesMurrumbeena Cricket Club Post #54490 deekdeek Posted Wednesday, February 19, 2003 4:34 PM SSC Journeyman Group: General Forum Members Last Login: Sunday, October 18, 2009 1:41 AM Points: 82, Visits: 19 the package runs fine from the designer. the issue is definitely with the line "dtsrun /SDHSBAYSQL05 /Udsperedelozzi /PMSMSDATA /NFull_Data_Import", as the error specifically points to the "/", although which one it is pointing to i do not know. any environment in which i run this line of code gives the same error. my question is: what is wrong with this SQL statement? Post #54491 philcartphilcart Posted Thursday, February 20, 2003 4:40 PM SSCrazy Group: General Forum Members Last Login: Tuesday, October 4, 2016 4:09 PM Points: 2,708, Visits: 1,411 Well for starters it's not an SQL statement, it's a CmdExec statement. That's probably the cause of the error.ThanksPhill Carter--------------------Colt 45 - the original point and click interface Hope this helpsPhill Carter--------------------Colt 45 - the original point and click interface Australian SQL Server User Groups-My profilePhills PhilosophiesMurrumbeena Cricket Club Post #54492 philcartphilcart Posted Tuesday, March 11, 2003 2:20 PM SSCrazy Group: General Forum Members Last Login: Tuesday, October 4, 2016 4:09 PM Points: 2,708, Visits: 1
van GoogleInloggenVerborgen veldenBoekenbooks.google.nl - This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database...https://books.google.nl/books/about/SQL_Server_DTS.html?hl=nl&id=_mh5d8JNmYEC&utm_source=gb-gplus-shareSQL Server DTSMijn bibliotheekHelpGeavanceerd zoeken naar boekenGedrukt boek aanschaffenGeen eBoek beschikbaarSams PublishingBol.comProxis.nlselexyz.nlVan StockumZoeken in een bibliotheekAlle verkopers»Boeken kopen Google PlayBrowse door 's werelds grootste eBoekenwinkel en begin vandaag nog met lezen op internet, je tablet, telefoon of eReader.Ga http://www.sqlservercentral.com/Forums/Topic10068-19-1.aspx nu naar Google Play »SQL Server DTSSteve Hughes, Jim Samuelson, S. Miller, M. SantosSams Publishing, 2002 - 485 pagina's 0 Recensieshttps://books.google.nl/books/about/SQL_Server_DTS.html?hl=nl&id=_mh5d8JNmYECThis book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner to https://books.google.com/books?id=_mh5d8JNmYEC&pg=PR7&lpg=PR7&dq=dtsrun+error+170&source=bl&ots=0S-r4IfBwf&sig=U1CA2gJQ9c-Qy9hNM-zChgn84TQ&hl=en&sa=X&ved=0ahUKEwiGg9Pa8sLPAhUC7oMKHS10CYMQ6AEIMjAD DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000. Voorbeeld weergeven » Wat mensen zeggen-Een recensie schrijvenWe hebben geen recensies gevonden op de gebruikelijke plaatsen.Geselecteerde pagina'sPagina xPagina ixTitelbladIndexInhoudsopgaveDTS in the ETL World3 DTS and Traditional Technologies4 DTS and Todays Technologies5 RealWorld Scenarios Used in This BookAbout Sparks Electronics6 DTSAn Overview7 The DTS Package8 Building a Package9 Summary36 Enhancing Performance228 Summary230 Automating Data Transformation Services231 Building a Package Using Visual Basic233 The Scenario234 Generating aVB DTS Package with SQL 2000 DTS Designer235 Including the DTS Script in a VB Application237 The DTS Object Model239 MeerConnections39 Datab
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a https://www.experts-exchange.com/questions/23406885/DTSRUN-Incorrect-syntax-near-'-'.html Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > DTSRUN Incorrect syntax near '/' Want to Advertise Here? Solved DTSRUN Incorrect syntax near '/' Posted on 2008-05-15 MS SQL Server 1 Verified Solution 4 Comments 721 Views Last Modified: 2013-11-30 I dtsrun error have a job that kicks off about 6 different steps, each step is its on dts. So i used the dtsrunUI to create the command argument but i get the following error "Error 170: Line 1: Incorrect syntax near '/' " This is what the command line argument looks like DTSRun /S "Test" /N "Project Review Reports Refresh" /G "{6CFF-4C28-BADA-019733F86