Who is online?  0 guests and 0 members
Home  »  search results

Search Results: DTSxChange

18 results found
  • Pragmatic Tools: DTSxChange (Or DTS Must Die!)
    Ah DTS packages...they suck. Seriously, it's 2011. It's been over a decade and we still have SQL 2000 and DTS packages lingering around our shops...sitting there...taunting us...asking to be upgraded but HOW? There's SO much work having to learn SSIS, fig
    Author: sqlchicken sqlchicken     Date: 6/7/2011     Section: Blog
  • DTS Runtime Required
    Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error :
    Author: ShawnHarrison ShawnHarrison     Date: 3/12/2010     Section: Blog
  • Benefits of DTSxChange
    DTSxChange is a wonderful tool that I’ve had the privilege of using while working on multiple DTS conversion projects. Not only does it make converting DTS packages to SSIS packages much, much easier, it also does the job in less than half of the ti
    Author: acoleman acoleman     Date: 8/1/2012     Section: Blog
  • ActiveX Script Conversions
    DTSxChange and Activex Scripts ? DTSxChange will convert simple activex scripts, but more complicated scripts it will not convert. It will add the code to a script task inside SSIS and comment it out. To finish the conversion where activex script was not
    Author: ogonzalez ogonzalez     Date: 1/16/2012     Section: Blog
  • Plan your DTS Migration with DTS xChange Profiler
    Converting DTS packages to SSIS can be a tedious and labor intensive undertaking.  If you are like some companies you now have possibly hundreds of these packages to convert and estimating the time and resources it will take to complete the conversio
    Author: TomLannen TomLannen     Date: 9/23/2011     Section: Blog
  • Convert your old DTS Packages with DTS xChange
    In my last post I told you about DTS xChange Profiler and how it can help you plan and budget a DTS to SSIS migration.  Now that the planning is done, and hopefully you now have the approval to go ahead with the project, let?s talk about how DTS xCha
    Author: TomLannen TomLannen     Date: 9/28/2011     Section: Blog
  • Help Me Help You With Free SSIS/SSRS Training
    As you've probably noticed, Pragmatic Works is once again running another promotion. This promotion is a little different though in that it's probably the best deal we've ever had on our software/training bundle. If your company purchases at least a singl
    Author: DustinRyan DustinRyan     Date: 4/20/2011     Section: Blog
  • DTS TO SSIS Migration
    You can easily replace this code with execute SQL Task For example your command is exec sp_MyStoredProc <bankID> then you need to set the following properties in Execute SQL task 1. Set connection type to OLEDB 2. Pick connection manager 3. Set you
    Author: NayanPatel NayanPatel     Date: 12/21/2009     Section: Forum
  • Quick Question
    1) SSIS is a completely different beast, a much better beast. There are lots of things that you can do in SSIS with native tasks that you simply couldn't do, or couldn't do without a lot of pain (read also: ActiveX programming), in DTS. I highly recommend
    Author: sqlchicken sqlchicken     Date: 5/3/2012     Section: Forum
  • Which data providers are supported in SSIS?
    Data-Connectivity Providers and SSIS Note: The following is not a definitive list of all data providers, and not all data providers on this list have been tested by Microsoft with SSIS. Only current Beta or shipping products are listed. Information about
    Author: BrianKnight BrianKnight     Date: 11/7/2009     Section: Blog
  • Pragmatic Works BOGO
    Did you know that Pragmatic Works is giving away free training for SSIS or SSRS? And no I’m not talking about our webinar series but our actually 4 day virtual training class. That’s a $800 value. Check out some of our upcoming classes here. The next ques
    Author: ChrisAlbrektson ChrisAlbrektson     Date: 4/21/2011     Section: Blog
  • How to loop through files in a specified folder, load one by one and move to archive folder using SSIS?
    In DTS if you want to process files in a specified folder then you have to do good amount of work. But If you want to implement same in SSIS then you don't have to do much work. You can use "Foreach Loop Container" in SSIS to loop through files
    Author: BrianKnight BrianKnight     Date: 11/7/2009     Section: Blog
  • Running DTS package in sql server 2008
    Do you have a lot of activex script in that package? Have you used DTS exchange or run a DTSxchange profie using the profiler?
    Author: ogonzalez ogonzalez     Date: 8/28/2011     Section: Forum
  • Pragmatic Works Software for MVPs
    This is just a quick post to remind folks who are current Microsoft MVP s that Pragmatic Works offers NFR licenses of its software ! This NFR offer includes: BIxPress - Audit, Notify, Deploy and Manage SSIS Packages BIDocumenter - One Stop Documentation S
    Author: sqlchicken sqlchicken     Date: 4/22/2012     Section: Blog
  • Want to get Free SSIS or SSRS Training?
    I have some really exciting news about our software and our products. From now until the end of April 2011, if you purchase any of our software, you will get 1 free seat in either our SSRS class or our SSIS class. Each of our classes is 4 days long, 3 hou
    Author: SMcDonald SMcDonald     Date: 4/20/2011     Section: Blog
  • Loss mouse function after virtual pc connection
    I recently experienced a problem with my mouse when I remoted into a virtual pc. Once logged in, I no longer could use the mouse to navigate my way through the screens. I am sure that a lot of us have struggled with figuring out what the hot keys are unti
    Author: SMcDonald SMcDonald     Date: 4/2/2010     Section: Blog
  • DTS to SSIS Migration Project
    With much fanfare, SQL Server 2012 launched earlier this year. With all the excitement about the new features, such as AlwaysOn Availability Groups, lots of new T-SQL functions, and ColumnStore Index, there are also features that go away. With each releas
    Author: KathiK KathiK     Date: 6/22/2012     Section: Blog
  • Awesome Software/Training Deal!
    Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps organizations with migrating packages from DTS to SSIS . We also have some pretty wicked software that saves time documenting packages, cubes an
    Author: briankmcdonald briankmcdonald     Date: 4/21/2011     Section: Blog
Page 1 of 1 (18 items)