Search results for query: *

Where does it state that the standard version of SQL does not have partitioning?

I did this by using a script task to assign the variable values and then you can choose the variable option from the destination manager in the data flow.

Can you post you the SQL. If it is the above you could either. If you are trying to declare the variable in the SQL Statement and then use that declared variable you might be out of luck. If you use a "script task" then Dts.Variables.Item("User::Var").Value = 1 If you use a going to...

MDXer. Thanks. I really never used the union all. I will have to give this a try.

I think that I know what you want. Have you used a "Execute SQL task?" This task allows SSIS to return a result set from a query and then you can set your variable(s) in the resultset tab. I use this for a listing of ID's that are to be processed and then "shred" it into a for each loop.

I would open the file and take a look. Then I would compare your SSIS data flow to that of your DTS. Then look at the SSIS settings for that file.

MDXer is correct use the derived comp to format the data. What I did for the same problem was to use a conditional split off the source and then a derived column to format. This way I could keep the data that had a bad date. Then I used the default condition to signal a good row and the first...

Are you going to set the package level variable in a script task? If so you just need to add the variables to the proper tab on the script task. ie User::Var1, User::Var2 This setting of variables and expressions gave me many headaches as I started using SSIS but after using them a few times it...

Wow. Thanks for the replys. I guess I still have a couple of follow up questions. 1. If I make it bootable and tehn copy all my files from the install CD is it then ready for action? 2. If I dont make it bootable am i going to need to use floppies to boot to command? or is there another way to...

I would like to be able to make a USB flash drive my primary way to install windows. ie with drivers and such. Any help would be great. IBACFII

I am trying to find out how to import or connect to an access db. It seems that the sql2005 x64 on a 2003 x64 machine does not like to connect to an access db very easy if at all. Any ideas\links would be great. IBACFII

Nope. There are many revisions of opterons below the 246 model that are not DDR400 compatable. I would look on AMD's website. Also 2CPU.com has several threads that discuss this. As I have several 242's and a couple of 250's with different revisions. I can attest to this fact first hand. Still...

Which processor do you have? What is the name of the core? I would also have a look at AMD.com as there are some amd 64 cores that do not support ddr400. Also try swaping memory try one then the other. IBACFII

Ok I think that my question is along the same topic. I am trying to merge mail from a SQL DB to this mailer document. I have one table with a top level listing. This would be the data that would need to define a different mailer, and then another table with the data for the mailer. My question...

Update. Win 2003 64 bit will run on an AMD OPteron machine and will be able to run sql 2000 32 bit version with out any compatibility problems or so says M$

HP shop? The server that we are looking at is from HP and its AMD? IBACFII

Isn't 64 bit SQl 2000 only for the Itanium? not a AMD 252? I thought that sql2k5 is the only one that will support 64bit amd? Maybe I am wrong. We are getting a new server and were thinking a quad proc amd based machine running win 2003 with SQL. I have heard that SQL 32bit and SQL64 cost the...

What about a 32 bit SQL 2000 on a Win 2003 x86? Will SQL have problems with this or will it just run 32bit and the OS will run 64bit? IBACFII

Thanks. Thats what I ended up doing sort of. I did in fact save most of the text to script the important parts and then I just had to tweak it to get it back to the most current version. Thanks for the help anyway. IBACFII

Yes I have the MDF and the log file. However, I do not have the ndf files. There is my problem. It wants the ndf in order to do any kind of attachdb. I was thinking that there maybe a way to fabricate these ndf files inorder to get the db back up? Thoughts? IBACFII