Maximum size of the SSIS String Variable?

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Cannot see Local Database template in Add New Item Dialog box Per MSDN instructions I downloaded the folliwng: .NET Framework 2.0, SQL Server 2005, SQL Server Compact 3.5, and Visual Basic Expess Edition. When following the tutorial to create a database, I was never able to see the Local Database template. I am taking the programming lessons in VB, and I am up to Creating Your First Datatbase. It is a requirement that SQL Server Compact 3.5 be installed. Which I have done. Tag: Maximum size of the SSIS String Variable?
  - 2
    - SqlDataSourceEnumerator.Instance; not returning all instances ...static void Main() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; System.Data.DataTable table = instance.GetDataSources(); ... Hi MS SMO folks, I'm not getting all instances returned in my table. I know there are issues surrounding this call but I have 1 dev box, 1 nt 2003 server and a total of 3 sql srv instances. 2 of which are on my local dev machine. All are 2005. Both servers have SQL Browser enabled and all protocols are enabled. All of my MacAfee and Windows firewalls are temporarily Off. The only instance returned is mylocalbox/sqlexpress. I can understand why it may not see the server, due router or other h/w, but what I really don't get is why it doesn't even see my other instance on my local box: mylocalbox/dbcdev1 Is there another more robust method of enumerating all sql instances on a LAN or getting this to work a bit better Thanks Jim Tag: Maximum size of the SSIS String Variable?
  - 3
    - Drillthrough (beginner) I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this: Years Counties Total Crashes Fatalities Cook 85 98 Manchester 2850 258 Sagamon 987 526 So when a user clicks a county, such as "Cook", this is displayed Years Age Gender Total Crashes Fatalities 0-8 Female 25 8 Male 55 15 9-15 Female 850 258 Male 185 35 16-22 Female 87 526 Male 10 35 But I am getting this in : Years Age Gender Total Crashes Fatalities 0-8 Female Male 9-15 Female Male 16-22 Female Male Whats going on Can anyone make any suggestions Just to let you know its based off of an Analysis Services Cube and not relational tables. Tag: Maximum size of the SSIS String Variable?
  - 4
    - DBCC TableResults Anyone know where I can find the "TableResults" table definition in order to create a table for the DBCC command I can't seem to find it in BOL... Tag: Maximum size of the SSIS String Variable?
  - 5
    - How can I get AS 2005 to use more than 2GB? I'm currenlty running AS 2005 on a Windows 2003 STD edition 32bit. I have added the /3GB switch in the boot.ini to that the server will use all 4GB. Unfortunately AS only appears to see 2GB based on the following error Memory error: The operation cannot be completed because the memory quota estimate (4095MB) exceeds the available system memory (1996MB). As you can see my the error AS only thinks the system has 1996MB of memory. I can confirm that there is 4GB of memory in the server and the OS can see 4GB memory Thanks for your help Tag: Maximum size of the SSIS String Variable?
  - 6
    - AS2005 Cube Excel 2007 Filtering Issue When browsing our AS2005 Cube we only have one filtering option. Top 10... under the Value Filters menu item. All other filtering options are disabled. I can create a pivot table manually from data in an excel worksheet and the filtering options work fine. Which leads me to believe it is something wrong with our cube design / metadata Any ideas for what we might need to have the filtering options enabled. Tag: Maximum size of the SSIS String Variable?
  - 7
    - Apparent Memory Leaks in ODBC We have created a multithreaded application that reads result sets from MS SQL Server (both 2000 and 2005). The MS SQL Server app and our app reside on the same machine. We are using the latest version of ODBC32.DLL (3.526.1830.0) and SQLSRV32.DLL (2000.86.1830). Our application is written in C++ using the Visual C++ 6.0 compiler and libraries. Our app runs as a service, therefore the apparent memory leak is a real problem. Our app needs to run on a server in a closet without human intervention. We are kicking off many user threads that each can read from the database tables. Each of the reads from the database occurs within a critical section to minimize the threads stepping on each other. The ODBC interface class follows all the steps defined in the ODBC application developers documention (see code below). We see or app memory steadily increasing over time (we used PerfMon to monitor Private Bytes and Virtual Bytes, per ODBC documentation). If we terminate the threads which are retreiving the result sets, the memory drops back to the level noted prior to starting the threads. The code below is admittedly inefficient, however, it should not leak memory when accessing the database. Note that it works very well, returns the result sets that we expect exactly. SQLHENV henv = SQL_NULL_HENV; SQLHDBC hdbc = SQL_NULL_HDBC; SQLHSTMT hstmt1 = SQL_NULL_HSTMT; SQLRETURN retCode; SQLSMALLINT sColCount = 0; CODBCInterfaceColumnList lColumnList; CString strDSN; CString strUID = _T("AccountName"); CString strPWD = _T("Password"); CString strServer; CString strDatabase; CString strDebugMsg; if(!CreateDSN( pRecordList->m_strDefaultODBCConnect, strDSN, strDatabase, strUID, strPWD, strServer)) { strExceptionMsg.Format( _T("Cannot create DSN from connect string %s"), pRecordList->m_strDefaultODBCConnect); bReturn = true; return bReturn; } if(pRecordList->m_strDefaultODBCConnect.IsEmpty()) { bReturn = true; return bReturn; } // Allocate the environment handle retCode = SQLAllocHandle(SQL_HANDLE_ENV,NULL, &henv); if(retCode != SQL_ERROR && retCode != SQL_INVALID_HANDLE) { // Set the environment to ODBC Version 3.0 retCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_ENV, strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a ODBC connection handle handle retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLConnect( hdbc, (UCHAR*)(LPCTSTR)strDSN, SQL_NTS, (UCHAR*)(LPCTSTR)strUID, SQL_NTS, (UCHAR*)(LPCTSTR)strPWD, SQL_NTS); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_DBC, strDebugMsg); OutputDebugString(strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a statement handle retCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Fixup the select statement retCode = SQLPrepare( hstmt1, (UCHAR*)(LPCTSTR)pRecordList->m_strSelectStatement, pRecordList->m_strSelectStatement.GetLength()); if(retCode == SQL_SUCCESS) { retCode = SQLExecute(hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLNumResultCols(hstmt1,&sColCount); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { if(sColCount > 0) { if(lColumnList.DescribeColumns(hstmt1, strExceptionMsg)) { if(lColumnList.BindColumns(hstmt1, strExceptionMsg)) { int i = 0; while((retCode = SQLFetch(hstmt1)) != SQL_NO_DATA) { if(retCode != SQL_SUCCESS) { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); break; } else { // Class to hold the result set. CTableColumnList* pColList = new CTableColumnList(); lColumnList.PopulateColumnListObject(pColList); pRecordList->AddColumnListRecord(pColList); } } } } } } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt1); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLDisconnect(hdbc); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } retCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); } } retCode = SQLFreeHandle(SQL_HANDLE_ENV, henv); We are at our wits end, not sure what to do next. Any help in sorting this out will be very, VERY much appreciated. Tag: Maximum size of the SSIS String Variable?
  - 8
    - reportviewer issue I am using the reportview in vb2005 to run a report that is on our report server. It just keeps says its processing and does not come up with any results. Any thoughts why this is happening and how I can fix Tag: Maximum size of the SSIS String Variable?
  - 9
    - From and Thru Date parameters I'm using MDX to query a cube. I have two identical data sets: WITH MEMBER [Measures].[ParameterCaption] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date Shipped].[Year-Month]. ALLMEMBERS ON ROWS FROM [Heidtman DW] How do I get one to be the "From" date and the other to be the "Thru" date I'm passing the correct parameters ([Date Shipped].[Month].&[2006]&[4]&[12]) & ([Date Shipped].[Month].&[2007]&[4]&[11]) but I don't know how to tell the query to use them correctly. Tag: Maximum size of the SSIS String Variable?
  - 10
    - Case expressions may only be nested to level 10 I'm running into this issue when I try to query a table (well a view) that was poorly designed and has many fields in the table as YesNo fields instead of a single field that just contains a value. (Fields A-N in the table for example) So my query looks like: CASE WHEN A = 1 THEN 'A' WHEN B = 1 THEN 'B' WHEN C = 1 THEN 'C' WHEN D = 1 THEN 'D' WHEN E = 1 THEN 'E' WHEN F = 1 THEN 'F' WHEN G = 1 THEN 'G' WHEN H = 1 THEN 'H' WHEN I = 1 THEN 'I' WHEN J = 1 THEN 'J' WHEN K = 1 THEN 'K' WHEN L = 1 THEN 'L' WHEN M = 1 THEN 'M' WHEN N = 1 THEN 'N' END AS GeneratedField Is there some other way I can approach this I can't change the table as it isn't mine, but I need to run a report that looks at those fields and in GeneratedField places the result for the field that was checked. Thanks. Tag: Maximum size of the SSIS String Variable?
  - 11
    - conditions in where clause Hi I am upsizing the access database to SQL 2005. I currently converting Access Query's to SQL stored procs and functions but i have got stuck on one issue. In access there is a update statement that has an IIF in the where clause, i have tried replicating this in T-SQL buy using case statement but it does not work. in access the where looks some thing like this Where IIF(table1.Column1 = 0,Table2.column1,Table3.Column1) Any one know how i can best replicate this behavior Dagz Tag: Maximum size of the SSIS String Variable?
  - 12
    - Stored Proc creation script in T-Sql I am trying to do the following: I need to execute a t-sql statement that contains the stored procedure creation script. In reality this will have differnt stored procedure creation scripts which will be created in different databases depending upon certain criteria. The example below is just for demo purposes. when i try to execute this in master it is showing me the following errors: USE MASTER GO declare @SQLString Nvarchar ( 1000 ) declare @STR Nvarchar ( 1000 ) declare @DBName nvarchar ( 100 ) SET @DBName = 'BTGenesisMDRockville' SET @STR = ' create proc sptemp @id int as select * from orders where id=@id go ' set @SQLString = 'USE ' + @DBName + char ( 10 ) + 'GO' set @SQLString = @SQLString + @str EXEC ( @SQLString ) Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'GO'. Msg 111, Level 15, State 1, Line 3 'CREATE PROCEDURE' must be the first statement in a query batch. Msg 137, Level 15, State 2, Line 6 Must declare the variable '@id' . Can anyone help me on this Tag: Maximum size of the SSIS String Variable?
  - 13
    - Report Builder and optional parameters Hi, Is it possible to create optional parameters in Report Builder An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. In latter case, the reports should not take the parameter into account and display all available data. Example: I have a list of products grouped by the name of the supplier. I want users to be able to see the entire list, or narrow it down to one supplier only. So I create a free text parameter that will contain a part of the supplier's name. It works ok, but if parameter is left blank, or set to NULL, the report will display no data (all products always have their suppliers). I tried to create a filter formula to check for empty value and bypass the filter if necessary, but the formula only allows me to use the parameter expression once. So I cannot check for empty value and apply the filter in the same expression. As a last resort, I used the following workaround: created a new formula named "Enter 'ALL' to see all suppliers" that would return text constant "ALL". I then added another prompted filter expression for this field and grouped it with my supplier prompt using "Any of" group. User is now able to choose a supplier, or enter "ALL" to the second prompt field. This clumsy approach actually works, but then another problem emerges - although I mark both filter fields as Prompted, the Report Builder will forget this flag for one of the fields when the report is reopened. I think it could be a bug (we use SQL2005 SP1) Anyway, it'd be nice if I could create an optional parameter as one expression, not two. Is there any way to do that TIA Denis Tag: Maximum size of the SSIS String Variable?
  - 14
    - Error - SQL Server requires Encryption On Hello All, I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens. Here is the connection string we use in the app.config file on the Pocket PC's: <add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/> Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here, Jack Tag: Maximum size of the SSIS String Variable?
  - 15
    - Applying snap shot at subscriber from DVD on SQL 2000 I want to send snap shots by DVD to a SQL2000 server from SQL2005. This config is replicating fine using trans replication with the publisher and distibuter on the source SQL2005 server. I am using push subscription to the SQL2000 server. I now need to create snap shots on the SQL 2005 server that I can send to the SQL2000 server using DVD. I know how to create the snap shot on the SQL2005 server but I cannot find any way to use it on the SQL2000 target server. Can anyone tell me how to do this Thanks Phil Tag: Maximum size of the SSIS String Variable?
  - 16
    - How can i encrypt or mask a column in the database How can i encrypt or mask a column in the database Any help will be appreciated Regards Karen Tag: Maximum size of the SSIS String Variable?
- Next
  - 1
    - Enterprise Manager returns [MS Visual Database Tools] - The parameter is incorrect when returning all rows When I try to return all rows from a view or table by selecting Open Table|Return All Rows from the context menu, I get a dialog in the middle of EM stating: An unexpected error happened during this operation. [MS Visual Database Tools] - The parameter is incorrect. Any ideas Tag: Maximum size of the SSIS String Variable?
  - 2
    - DataFlow Update? Hi, I'm wondering if it is possible to make an update of a specifics rows in a database table using dataflow tasks thanks Tag: Maximum size of the SSIS String Variable?
  - 3
    - New Log or append? I'm backing into the DBA position from being an app / web designer. Using SQL 2005 and hating wizards, I'm trying to code a BACKUP LOG query to run every 15 minutes and create a separate date-time-stamped TRN. I have several questions starting with - should I be doing this Is it better to create separate LOGs or append to one Isn't it true that the only time I'll need the LOGs is when I have a crash and that then I'll need to RESTORE in date-time-order I'm doing a FULL backup every 6 hours and intend on automating deleting the TRNs on a successful completion of the BAK. The following code runs fine and creates a date-time-stamped TRN but doesn't do what I want, as it overwrites the first TRN, so how do I create, say, four JOBSTEPs and get a JOBSTEP @COMMAND to run the SETs USE msdb IF EXISTS ( SELECT Name FROM sysjobs WHERE Name = 'jobDBBackupWedb_1Log' ) EXEC sp_delete_job @job_name = 'jobDBBackupWedb_1Log' GO DECLARE @now char ( 14 ) -- current date in the form of yyyymmddhhmmss DECLARE @dbName sysname -- database name to include date-time-stamp DECLARE @Cmd nvarchar ( 260 ) -- variable used to build JobStep command SET @now = REPLACE ( REPLACE ( REPLACE ( CONVERT ( VARCHAR ( 50 ), GETDATE (), 120 ), '-' , '' ), ' ' , '' ), ':' , '' ) SET @dbName = 'Wedb_1_' + @now + '_.trn' SET @Cmd = 'BACKUP LOG Wedb_1 TO DISK = ' + CHAR ( 39 ) + '\\SERVER1\D$\SQLDatabases\Backup\WebEoc\' + @dbName + CHAR ( 39 ) EXEC sp_add_job @Job_Name = 'jobDBBackupWedb_1Log' , @Description = 'Run Wedb_1 DB Backup Transaction Log Every 15 Minutes' , @Category_Name = 'Database Maintenance' EXEC sp_add_jobstep @Job_Name = 'jobDBBackupWedb_1Log' , @step_name = 'DB_Backup_Log' , @step_id = 1 , @Database_Name = 'Master' , @subsystem = 'TSQL' , @command = @Cmd /* Start time for the Transaction Log backups is seven and one half minutes after midnight to not conflict with the Full database backups run every 6 hours starting at midnight. The Transaction Log backups are to be run every fifteen minutes. */ EXEC sp_Add_JobSchedule @Job_Name = 'jobDBBackupWedb_1Log' , @Name = 'schedDB_BackupLog' , @Freq_Type = 4 , -- Daily @Freq_Interval = 1 , -- Each day @Freq_Subday_Type = 0x4 , -- Interval in minutes @Freq_Subday_Interval = 15 , -- Every fifteen minutes @Active_Start_Time = 000730 -- Start Time is seven and one half minutes after midnight --@Active_End_Time = 235959 -- End Time is next midnight EXEC sp_Add_JobServer @Job_Name = 'jobDBBackupWedb_1Log' GO Tag: Maximum size of the SSIS String Variable?
  - 4
    - JIT Debug HELP See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at HP.CUE.Video.PlaybackControl.UpdateProgressBar() at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime) ************** Loaded Assemblies ************** mscorlib Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll ---------------------------------------- hpqimzone Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe ---------------------------------------- hpqiface Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll ---------------------------------------- System.Windows.Forms Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- System.Drawing Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- System Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll ---------------------------------------- hpqcc2 Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll ---------------------------------------- hpqutils Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll ---------------------------------------- hpqfmrsc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll ---------------------------------------- hpqtray Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll ---------------------------------------- hpqovskn Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll ---------------------------------------- hpqimvlt Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll ---------------------------------------- hpqimgrc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll ---------------------------------------- hpqntrop Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll ---------------------------------------- Interop.hpqcxm08 Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll ---------------------------------------- System.Xml Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll ---------------------------------------- LEAD Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll ---------------------------------------- LEAD.Wrapper Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll ---------------------------------------- LEAD.Windows.Forms Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll ---------------------------------------- LEAD.Drawing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll ---------------------------------------- interop.hpqimgr Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll ---------------------------------------- hpqthumb Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll ---------------------------------------- hpqasset Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll ---------------------------------------- hpqmirsc Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL ---------------------------------------- hpqedit Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll ---------------------------------------- hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll ---------------------------------------- LEAD.Windows.Forms.DrawingContainer Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll ---------------------------------------- hpqmdmr Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll ---------------------------------------- LEAD.Drawing.Imaging.ImageProcessing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll ---------------------------------------- hpqimlib Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll ---------------------------------------- hpqglutl Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll ---------------------------------------- Interop.hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll ---------------------------------------- ************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog. Tag: Maximum size of the SSIS String Variable?
  - 5
    - Displaying member name instead of key in query In the tools that I have used for getting generated MDX queries (Query Analyzer, Proclarity, Excel) the query always seems to show the key value instead of the member name. Is it possible or is there a query tool that will generate queries with the member name instead See example: [Organization].&[152551] Should read [Organization].[By Division] thanks, Andrew Tag: Maximum size of the SSIS String Variable?
  - 6
    - Simple select statement gone wild!! I am very new to sql and would like some help with a simple select statement. I am trying to pull birthdates using the following code. I can get the query to run but some of the dates are not between the parameters. What am i doing wrong SELECT Employees.EmployeeStatusID, People.FirstName, People.LastName, People.BirthDate FROM Employees FULL OUTER JOIN People ON Employees.SystemAssignedPersonID = People.SystemAssignedPersonID WHERE (People.BirthDate BETWEEN '10 - 01 - 1900' AND '12 - 15 - 2007') ORDER BY People.BirthDate <<<<<<<<<<<<<<<<<<<<<<<<<< Results A KWANG TAK 10/25/1929 12:00:00 AM T ETHEL MOE 5/24/1933 12:00:00 AM T GILBERT BARAJAS 1/9/1937 12:00:00 AM A EDILBERTO PENA 2/10/1937 12:00:00 AM Tag: Maximum size of the SSIS String Variable?
  - 7
    - Missing DLL during installation XP PRO SP2 I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install. Log SQL0003_mycomputername_SQL contains these errors: Error Code: 17750 MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. SQL_ERROR (-1) in OdbcStatement::execute_batch sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.). sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population. Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: lib\odbc_statement.h Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcStatement::execute_batch@sysdbupg.sql@113 Source Line Number: 91 Log SQL0003_mycomputername_Core reported: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750 Aborting queue processing as nested installer has completed Message pump returning: 17750 Log SQL003_mycomputername_Core(Local) reported: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run: Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition: Condition "The Clustered SQL Server instance that hosts is installed." returned false. Running: ReportChainingResults at: 2007/8/11 18:27:5 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 17750 Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults: erform Source Line Number: 3521 ---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch: ostCommit sqls::HighlyAvailablePackage: reInstall led due to cancel code received from cancel source: 29539 Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5 Message pump returning: 17750 No other log contained a related error message. A third attempt to install resulted in a Failure to create database files. Tag: Maximum size of the SSIS String Variable?
  - 8
    - Issues importing from Visual FoxPro 7 I'm trying to bulk load tables in SQL 2005 from a Visual FoxPro 7 database. We have the latest VFP OLE DB driver loaded and have run into an odd issue. When viewed from the table designer in VFP the tables have all columns set to not null (null column is not checked). However there are lots of rows with "empty" values for columns with both numeric and date data types. When I select these columns from an ODBC test app with the old (version 6.something) odbc driver they are filled with spaces. When I run a select on the tables from SQL 2005 these "empty" values come back as a default value based on the columns data type; 0 for numeric columns and 12/30/1899 for date fields. Now, for the first question, from the OLE DB side of things, is there a way to prevent the OLE DB driver from manufacturing data I can use a case statement to catch and remove the default date as 12/30/1899 isn't in the data. But there is no way to know when a returned 0 for a numeric field is a a valid value and when it was stuffed because the so-called non-null field had no value in it. Or if not, part two, can the old version 6 odbc driver be used from SQL 2005 I have a system DSN defined that works from an ODBC test app when using ODBC 2.0 syntax, but SQL 2005 doesn't seem to want to connect to it. linked server created with: EXEC master . dbo . sp_addlinkedserver 'ODBCLINKTEST' , '' , 'MSDASQL' , 'SystemDSN' and the query results... select * from [odbclinktest] ...tablename Msg 7313, Level 16, State 1, Line 1 An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "odbclinktest". Any hint, tips, tricks, etc. greatly appreciated. Thanks, Ed Tag: Maximum size of the SSIS String Variable?
  - 9
    - problem in connecting to sql server Express Hi to all, i'm installing sql server in my pc as netwrok service. when i try to connect it, it showing me a error sql server does not allow remote connections error 26 error locating server/instance (MS Sql server ) how can i resolve this plz help me out. it not able to connect the server locally. when i try to connect it with .\SQLEXPRESS or localhost\SQLEXPRESS it will connect to the DB But when i use ServerName\SQLEXPRESS it wont connect to DB what the problem plz help me with Regards Amjath Tag: Maximum size of the SSIS String Variable?
  - 10
    - Drilldown/interactive chart Hi Friends! I m working on a learning BI project in MS Analysis Services 2005.I have designed a cube having tea production quantity as measure and district,garden,time are dimensions.This cube is designed to analyze tea production of several gardens of a producer. Here is the relation between measure and dimension: A GARDEN(Dimension) of a DISTRICT(Dimension) produces certain amount of tea (Measure) for a particular TIME(Dimension) My quesion is : I am using a chart to show the tea production.Initially the chart shows Production as Y-axis,Year as X-axis and District as Series.I want to add a drilldown feature in the chart so that it can be drilldowned to Quarter even Month level.I have Quarter and Month as hierarchy in the Time dimension. Thanks in advance for answering this question. Regards, Chandan Tag: Maximum size of the SSIS String Variable?
  - 11
    - Calcaluting total nu of people based on their name field I want to create a report which should be looked like this. Members Joined Members Borrower Depositor Members Joined Yesterday 8 4 4 Members Joined Last 7 days 39 20 19 Members Joined Last 30 Days 243 120 122 Members Borrower Depositor 2007 Members Joined to Date 1,052 510 542 Q1-07 415 200 215 Q2-07 445 210 235 Q3-07 (To date) 192 100 92 All Members Joined 1,052 510 542 In the data base, there are some tables called members, loans and deposits containing members names, joined date , etc. Example: MembersTable MemberName MemberID etc LoansTable MemberName CommencedDate DepositorTable MemberName CommencedDate I assume that I should be able to create a report using matix format. But I want to clarify few things before I start. How do I calculate nu members Data base tables contains only names of the members but not numbers. Other thing is how can I group members by perticular time periods as shown above Do I need to use parameters Also In the table, members can be borrowers or a depositors How can clarify this one Please Can anyone give an idea How to start and which direction I should go etc Thanks Tag: Maximum size of the SSIS String Variable?
  - 12
    - generate report using recordset I am generating crystal reports using recordset in ASP.Now i want to generate the report using reporting services 2000 with the same recordset.how can i do this.pls suggest me. Thanks Tag: Maximum size of the SSIS String Variable?
  - 13
    - Slowly Changing Dimension [58] Error i am using SCD to insert or update .my source and destination table are Oracle and i am using Orcale OLEDB provider . i am getting the following error while executing the package.what could be the solution [Slowly Changing Dimension [58]] Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E5D Description: "Parameter name is unrecognized.". Thanks Jegan Tag: Maximum size of the SSIS String Variable?
  - 14
    - bug: name change of connection manager is not propogated through package create a package with a connection manager reference the manager with a bunch of tasks change the name of the manager stand back in disbelief as you receive the following message Error: 0xC004800B at Data Flow Task, DTS.Pipeline: Cannot find the connection manager with ID "SourceConnectionExcel" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "runtime connection "OleDbConnection" (8)" in the connection manager collection of "component "Source - 'DCD MANUAL$'" (1)". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID. SSIS SSUX Tag: Maximum size of the SSIS String Variable?
  - 15
    - Default date '1899-12-30 00:00:00.000' Hi, Date field in one of the tables is Nullable. Some rows contain NULL while some other have it as '1899-12-30 00:00:00.000' While processing the cube on this table, both NULL and '1899-12-30 00:00:00.000' get converted to Blank. Does anybody have any idea why this happens and if there is any workaround to show values exactly as they are. Thanks. Tag: Maximum size of the SSIS String Variable?
  - 16
    - DT_I8 versus DT_UI8 Can some one tell me in basic terms the difference between a signed and unsigned integer When would you decided to use one over the other I'm looking for it more in layman terms than a technical bit level discussion. Tag: Maximum size of the SSIS String Variable?

Clay Smith

In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)

Re: Maximum size of the SSIS String Variable?

Jamie Thomson

I think its 4000 but I could be mistaken.

Re: Maximum size of the SSIS String Variable?

jwelch

4000 is the limit on expressions. I'm not sure what the limit is on strings.

Re: Maximum size of the SSIS String Variable?

Phil Brammer

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...)

Re: Maximum size of the SSIS String Variable?

Matt Masson - MSFT

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).

Re: Maximum size of the SSIS String Variable?

Clay Smith

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.

Re: Maximum size of the SSIS String Variable?

jwelch

Post back and let us know.

Re: Maximum size of the SSIS String Variable?

Clay Smith

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.

Re: Maximum size of the SSIS String Variable?

Leon Ford

Can you let us know how you loaded this many characters into the SSIS string variable