Answer Questions

• GavinLaz Reading more than 1 set of files using Foreach Loop Container

  Hi, My requirement is I have to read 2 sets of files from a folder. For example, I have to read all files starting with either 'a' or 'b' only. In 'Foreach Loop', if I say 'a*,b*', it is not working. Instead of comma (,), I tried colon, semi-colon and pipeline characters also. It is not working. So I am using 2 loops now. But I would like to know is there any way to do it using a single loop Thanks. You can't code this condition in ...Show All

• Carlos Pérez Problem with Execute SQL Task

  I am having problems creating an "Execute SQL Task" which calls a stored procedure. I have tested the procedure successfully using parameters that I have hardcoded on the command line (i.e., EXEC procedure_name 1, 2). This works fine, but I'm having problems using variables(i.e., EXEC procedure_name @VAR1, @VAR2). I'm using a ConnectionType of OLE DB. When I parse the Query I get an error message that says "The query failed to parse.  ...Show All

• C3i SSIS LOGGING

  Second time around w/this one. I'm running my sqlserveragent with a domain admin account and everything works well. I then switch to a domain user and the package fails. Windows app log contains ths Package "Package1" failed. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . So I go to the sql server agent jobs and select the job I'm trying to run. I then go to Job Step Properti ...Show All

• zfjaj How to install sql server 2005 developer edition over sql server express.

  Hi, I have VS 2005 team suite , msdn , vss and sql server express 2005 edition installed on my windows xp system. Now I want's to installed sql server 2005 developer edition instead of sql server express edition.Also I have some important Databases so i don't want's to delete them want's them to be appear in sql server 2005 developer edition(which I am going to install.(I don't want's the sql server express instance) I have copied files ...Show All

• JungleFreak visual studio running too slow

  Hi friends after working visual studio (on my report model project) few minutes it runs too slow. i mean clicking on entities ,attributes takes ages to finish. I opened task manager i see "devenv.exe" is taking more than 800,000 k !! am using sql server 2005 standard edition. have you seen similar problem. Thanks for your help. Hi Jon Thanks for quick and detailed reply on this one. sorry to interrupt your work. its become very ...Show All

• raaman "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• t_m_ram Can the SQL Server 2005 be installed on Windows 2003 SP1?

  I recently attempted to install Windows 2003 SP1 on a machine on which someone had previously installed SQL Server 2005.  The build number for the SQL Server 2005 installation is 9.0.1116.  (BTW, which CTP is this build number ) The installation of the service pack seemed to go okay, but I soon got calls from users reporting that they could not log in to the instance.  I investigated, and discovered that the SQL Server servic ...Show All

• GwapoJoe full text index is exist or not

  Hi, How to find full text index is exist in the table or not like that how to find normal index is exist in the table or not Thanks in adv. ---> Murali <---- Please refer to Books Online "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx In your case you should use OBJECTPROPERTY function and TableHasActiveFulltextIndex property. OBJECTPROPERTY(table_id, ' ...Show All

• SathyaKV variable visibility within an integration services project

  im creating an sql2005 integration services project ( DTS). i am creating a user variable. i want to be able to use that variable inside a script task. how do i reference the variable so that it can be seen within the script task http://blogs.conchango.com/jamiethomson/archive/2005/02/09/964.aspx My opinion has changed slightly since I wrote this mind you. I generally prefer using ReadOnlyVariables/ReadWri ...Show All

• Derek Dabeach SqlCommand Return and Output Parameters Not Working, but Input does?

  The foolowing code I cannot seem to get working right. There is an open connection c0 and a SqlCommand k0 persisting in class.The data in r0 is correct and gets the input arguments at r0=k0->ExecuteReader(), but nothing I do seems to get the output values. What am I missing about this System::Boolean rs::sp(System::String ^ ssp){ System::String ^ k0s0; bool bOK; System::Data::SqlClient::SqlParameter ^ parami0; System::Data::S ...Show All

• Gene B. 3 Constraint and Linked Server query problem

  Hi, I've got a problem querying a remote table via linked server (SQL Server 2000 SP4). If I do select * from <linked server>.<database name>.<db owner>.<Table1> it returns all data, as expected. However, if I do: select * from <linked server>.<database name>.<db owner>.<table name> where ColumnID = 51588 it doesn't return a row, even though it exists in the remote table. A likely reason for ...Show All

• davidb64il SQL Server Data Archiving

  I have two SQL Server db's that I have to delete a bunch of old data from. What is the simplest and quickest way to accomplish this Yes I'm new to DBA tasks. Any help will be greatly appreciated. Thanks ...Show All

• fihs_johnW Problem in processing the cube for MSAS2005

  Hello everyone, I have a problem in processing the cube for MSAS2005. this is what I have done please guide me to solve the issue. Steps: I have an OS of WIN2k3 with SP1 I have installed MSAS2000 with SP3 and then Installed SP4 Now I have installed MSAS2005(I have selected everything in order to create a server installation and then clicked on the advanced button to make sure nothing is missing out.) While the dia ...Show All

• raewear SSMSE Cannot show requested dialog

  In Database Properties | Permissions when I highlight a "user or roles" and click "Effective Permissions" I get an error dialog as indicated below.  Given that this is beta software, is it a known bug, or is it something I'm doing John =================================== Cannot show requested dialog. =================================== Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\C ...Show All

• IsshouFuuraibou MDX Sum syntax problem

  Hi All, I'm extremely new to MDX, and I'm having some trouble getting one of my expressions to work. I would appreciate any help with this hopefully easy problem. I have a cube like this: Subcription_CruiseId HomeAirportId AccountId With dimensions like this: (related to Subcription_CruiseId) SubscriptionStatusId SubscriptionStatus (related to HomeAirportId) AirportId AirportCode The account id is a measure that has a distin ...Show All