Hi,
How do I check the version of Mdac in sql box?
Thanksuse a tool from MS called ComChecker...
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||http://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
--
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I check the version of Mdac in sql box?
>> Thanks
>sql
Showing posts with label box. Show all posts
Showing posts with label box. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
Maximum size of the SSIS String Variable?
In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?
I think its 4000 but I could be mistaken.
|||4000 is the limit on expressions. I'm not sure what the limit is on strings.
|||
jwelch wrote:
4000 is the limit on expressions. I'm not sure what the limit is on strings.
This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)
|||I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).
|||I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.
I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.
|||Post back and let us know.
|||I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.
This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.
|||Can you let us know how you loaded this many characters into the SSIS string variable?
Maximum size of the SSIS String Variable?
In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?
I think its 4000 but I could be mistaken.
|||4000 is the limit on expressions. I'm not sure what the limit is on strings.
|||
4000 is the limit on expressions. I'm not sure what the limit is on strings.
This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)
|||I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).
|||I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.
I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.
|||Post back and let us know.
|||I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.
This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.
|||Can you let us know how you loaded this many characters into the SSIS string variable?
Maximum size of the SSIS String Variable?
In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?
I think its 4000 but I could be mistaken.
|||4000 is the limit on expressions. I'm not sure what the limit is on strings.
|||
4000 is the limit on expressions. I'm not sure what the limit is on strings.
This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)
|||I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).
|||I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.
I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.
|||Post back and let us know.
|||I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.
This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.
|||Can you let us know how you loaded this many characters into the SSIS string variable?
Subscribe to:
Posts (Atom)