Search results for query: *

Hi, How and where do I apply the WITH (maxdop=1) hint to an update stmt? I am looking for the correct syntax. example - similar to my query in structure) UPDATE myTable a SET col1 = x, col2 = y, col3 = b -- complexity hidden FROM myTable b LEFT JOIN anotherTable... Thanks much

Hi, SQL Server 2005, SP2, 32 bit, 4 processors Stored proc runs and never finishes... I am seeing a lot of CXPACKET wait times on an UPDATE statement in a stored procedure. Research on the internet seems to point to poor usage of parallelism among the processors, or something to that effect...

Hi, The Microsoft web site gives 3 choices of SP2. I have no idea which version is the correct on for our server. Can someone please explain to me how I can determine which service pack to download? THANKS SQLServer2005SP2-KB921896-IA64-ENU.exe SQLServer2005SP2-KB921896-x64-ENU.exe...

Hi, just trying to "quickly" figure out what this batch file is doing... I think it's putting a time stamp on some files, but I don't get the "FOR %%A IN (0 1 2 3 4 5 6 7 8 9)" part. Thanks much REM Use ERRTIME.EXE for a sorted date (or time) in MS-DOS 7.* ERRTIME -y > NUL FOR %%A IN (0 1 2 3...

Hi, I am converting several DTS pkgs to SSIS. Several of the pkgs contain complicated "Active X script" transformations on text files. That is, it would take me a long time to have to re-write this! In the meanwhile, do you think it's just best to use the EXECUTE DTS 2000 task until I have a...

Hi, I have been in the process of creating some new pkgs in BIS. My question is, once I am done writing the pkgs, what next? That is, how do I get the pkgs into SQL Server, and how do I schedule them to run? Also, what if I have the following scenario: I have created a new SSIS pkg that has...

Hi, Here's my problem. I have 2 tasks defined in my Control Flow tab: EXECUTE SQL--------->EXECUTE DTS 2000 PACKAGE When I attempt to run it, by right-clicking the EXECUTE SQL task, and selecting "Execute Task", it only runs the EXECUTE SQL part (successfully), and does not "kick off" the...

Hi, I'm also posting this on SSIS boards, but I need all the help I can get. I am trying to execute a Data Flow Task. There is only one task in the data flow task so far, and that is a Flat File Source task. I also set up a Connection Manager for the file, myfile.txt. When I try to run the...

Hello, I am attempting to set up a Connection Manager for a Flat File Source. Data in my flat file is like this, for example: "038188306","03/02/2007" "038C88328","9A9990846","INFYSW ","L","Z98ZVL97R","2006-06-02" Row 1 has two columns, Row 2 has six columns (as delimited by the...

Hi, I am in the process of converting a DTS pkg to SSIS. In the connection manager I get this error when I click on "columns": The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data...

Hi, I am attempting to migrate a DTS package to 2005. Several of the steps in this particular pkg involve a "Data Transform" task, which according to my SSIS book, have a low probability of successful migration due to the complexity of the data transform. So, it looks like I will have to...

Hi, I imported and migrated a DTS package from 2000 to 2005. Where am I supposed to store this package? Right now I have it in a folder I created under "Projects" Thanks

I have 2 servers... one has 2000, the other has 2005. I would like to try using the Migration Wizard to convert a DTS pkg to an SSIS pkg. How, and forgive me if I don't sound like I know what I'm doing because I don't, do you "move" a DTS pkg to the 2005 server, so as to be able to run the...

Hi, I am on the "Feature Selection" screen, which is where you end up if you click "Advanced" I need to change the installation path so that my system databases are on the D drive, not the default c:\program files. However, what about Reporting Services, Notification Services, Integration...

Sorry for my lame questions. I just uninstalled my instance of sql server 2005 and related components such as SSIS, notification services, etc. However, I still see a bunch of 2005 related stuff installed in add/remove programs. I assume these were installed during the 2005 installation, so...

Hi, I've done this before a long time ago so I forget... how can I tell if IIS is installed on my Windows 2003 server? If it's not installed, how do I get it on there and configured? Thanks much

Hi, This is the log file for my SP1 on 2005 install. Can anyone please look at this and tell me if this looks normal? I'm concerned about the following in the log: "Failed to read registry key: Debug" AND all the entries that show "- Not Applied" What does this mean? According to SELECT...

Hi, In 2005, you can enable OPENROWSET support under Surface Area Configuration. Where does one enable OPENROWSET support in SQL Server 2000? Thanks much!