May 2007
Intermediate to advanced
432 pages
11h 43m
English
Content preview from Expert SQL Server™ 2005 Integration Services
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
9.9. 64-Bit Issues
As mentioned earlier, DTExecUI.exe is a 32-bit application. Because of this, whenever you execute a package from DTExecUI.exe, it will execute in 32-bit mode even if you are running it on a 64-bit machine, which could potentially cause it to take longer to execute. Much of this is because data must be marshaled back and forth between 32-bit mode and 64-bit mode. To get around this problem, you can go to the Command Line page of this tool (shown earlier in Figure 9-10), copy the command out of the window, and paste it into a command prompt, prefixing dtexec.exe in front of it.
On a 64-bit machine, DTExec.exe comes in two flavors: 32-bit and 64-bit. The 32-bit version is stored in the \Program Files (x86) directory and the 64-bit version is stored in the main \Program Files directory. Occasionally, the environment variables may have issues and point to the wrong C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ directory. You can fix this by right-clicking My Computer on the desktop and selecting Properties. Go to the Advanced tab and select Environment Variables to produce the screen shown in Figure 9-19. From the System variables section in the lower portion of the window, select the Path variable and click Edit. In the next window, you will see several delimited paths to various folders on the system. Look for the path referring to the Binn directory mentioned earlier. Ensure here that this path is set to \Program Files and not \Program Files (x86) and click ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.