Recent content by IBACFII

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$