Answer Questions

• Animal One FTP Connection Manager: Set FTP password using a variable

  Hi, I want to setup an FTP task that is portable in the sense that all it's connection parameters are stored in variables. I can create expressions for properties ServerName and ServerUserName but not the ServerUserpassword.  Is there an property that I missed, there seems to be properties for everything else except the key piece of info, the password. I could create a script component using the FtpClientConnection method as a las ...Show All

• YRa UniqueIdentifier error in SSIS

  Hi, I got problem when i am sending the data from source to destination. My source is Sql Server 2005 and My Destination is Sql Server 2005. In Source table the column name is defined as numeric datatype. In Destination table the column name is defined as UniqueIdentifier. When i send the data from Source to Destination i am getting this error. [Data Conversion 1 [4190]] Error: Data c ...Show All

• Hostwap Numerous (every 10 minutes) Event log entries

  Hi, Every 10 minutes, I get and information application event log of type ID:17137 Info: Starting up database 'ReportServer$SQLExpressTempDB' This is a brand installation of the Express SP1 advanced package and the reporting service has not been yet used. Thanks Hi Mike, Thanks for the detailed and informative answer. The RS is working well, so its merely an annoyance but not a functionality ...Show All

• dagma20 AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous ...Show All

• Christineeve Transfer Access database into SQL Server 2005 Express

  Hi, A question regarding SQL Server 2005 Express edition. Is it possible to export Access databases into SQL databases without using programming (e.g. using SQL and programming languages) I understand you can do this with DTS, but the Express edition seems not have DTS. Many thanks Yuelin I tried to login using the "sa" user id but I receive the same error. ...Show All

• PiperPilot Where is the AWDataWarehouseRefresh sample? Missing from SQL 2005 April CTP

  The sample directory for the AWDataWarehouseRefresh is empty except for the readme file which says: "Please look for this on beta place, https://www.betaplace.com ." I visited the betaplace site and didn't find any samples. Anyone know where it is Mark Hi Mark, The samples team told me that the sample did not actually get posted to betaplace. It will, however, be included in the June CTP release.  Sorry ...Show All

• kareddy Underscores in column names disappear in script component

  Hi, The column names I'm using often have underscores in them. I've noticed that, when writing script in the script component editor, the underscore characters mysteriously dissapear. Is this a known bug (I can't find any reference to this by Googling) Thanks in advance, Lawrie. Kirk, Any underscore in a column name always disappears within the script component. Doesn't change the pipeline metadata of cours ...Show All

• Thomas2054 SSSB Error Message

  What could be causing the following: This message could not be delivered because its message timestamp timestamp has expired or is invalid. Thanks. In our case, we have a central site in US that commuincate with many sites in Africa, Europe and Asia. Is there any way (configuration) we could make those sites talk. If the scenario involves two machines, most likely the cause ...Show All

• Barbara S Foreach NodeList Enumerator

  Does anyone have any experience of using the NodeList enumerator in a Foreach loop BOL is a bit light on this. I want to enumerate over an XML Document that is passed into my package. The package is executed from a .net application. Has anyone done anything like this Any demo material Should I pass the XML Document into an SSIS object variable or a String variable Can the NodeList enumerator enumerate an XML document that is stored in a Str ...Show All

• Fabio Vazquez About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• Tony Lee Failed to install IDE using September CTP

  While installation of September 2005 CTP, the installation failed to install ID E SQL projects . Is this known issue or did I miss any thing. Regards, V SQL Server 2005 does not ship Visual Studio 2005 SQL projects. You would need to install it separately. Thanks, -Vineet. ...Show All

• The Markus Using stored procedure as OLE DB source with parameters from package variables

  Hi Guys, (I have searched this forum extensively, but still can't find the solution to this problem) Here it is: I have step in my ETL process that gets facts from another database. Here is how I set it up: 1) I have to package variables called User::startDate and User::endDate of data type datetime 2) Two separate Execute SQL Tasks populate those variables with appropriate dates (this works fine) 3) Then I have a Data Flow T ...Show All

• microdirectx rsExecutionNotFound

  I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error: Reporting Services Error I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled. You can workaround this ...Show All

• cool_chandu Message Queue Task 64 bit Cluster issue

  Hello, I'm using the Message Queuing task to create a local private queue message. Everything works great on a 32 bit machine. When I try this on a 64 bit Itanium Cluster I keep getting the message "Message queue service is not available" in my SSIS log. I've using this string as my path "ClusterName\private$\QueueName". Does anyone know of any issues with the Message Queue task on 64 bit or a cluster The Message Queue se ...Show All

• CrushDaByte Migrating from SQLServer2000 to SQLServer2005 SSIS solution

  Hi, We need to migrate data from Sqlserver2000 database to Sqlserver2005. The SQLserver2000 DB was poorly Normalized and the DB was redesigned inSqlserver 2005. Both the databases are operational.Currently we have around 90 tables that need to migrate the data from the OLD DB to NEW DB, all the table mappings between the old schema and new schema have been successfully established. Each Table is treated on its own merit and applying its ow ...Show All