Answer Questions

• r3n 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 Task with OLE DB source that uses a call to a sproc of the form "exec ETL_GetMyData @startDate = , @endDate = " with parameters mapped accordingly (0 -> User::startDate, 1 -> User::endDate) When I run this I get an error 0xC0207014: "The SQL command requires a parameter nam ...Show All

• wpdehn Transaction log keeps growing

  I have set the dboption 'trunc. log on chkpt.' to true; yet the transaction log keeps on growing. sp_dboption pubs_db does show 'trunc. log on chkpt.' to be set. I tried DBCC SHRINKFILE ( pubs_db_log , 100 ) and for a while, the pubs_db_log.ldf was about 100M and then it grew to 10GB. I have a process running that is inserting more than 15K rows per hour and I would like to keep the transaction log from growing. How do I control the tx log growth Just some ideas I'm not an expert.  Does the 15k rows per hour actually account for the 10GB log   Sounds excessive, maybe there are other major db changes going on such as re-indexing at regular intervals.  If your database is in FULL ...Show All

• Neotech management studio does not work

  Hi, I get TITLE: Microsoft SQL Server Management Studio ------------------------------ Exception has been thrown by the target of an invocation. (SQLEditors) ------------------------------ ADDITIONAL INFORMATION: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'Microsoft.SqlServerCe.Client' is already present. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 128) (System.Configuration) ------------------------------ Column 'InvariantName' is constrained to be unique. Value 'Microsoft.SqlServerCe.Client' is already present. (System.Data) ------------------------------ BUTTONS: OK -------------------------- ...Show All

• MrJul Error 18452 (not associated with a trusted sql server connection)

  Using sql2005 on a Novell network... When attempting to log into Mgt Studio using windows authentication I am getting the error: Error 18452 (not associated with a trusted sql server connection) . I added my domain\userName in sql with no problems and added the account to the sysadmin server role. However, I noticed my credentials on my pc are not listed as domain\userName but rather ComputerName\UserName. I think this is what is causing the problem but I am not sure. Can anyone lend a hand I'd appreciate any help, Thanks. Scott I had the same message when trying to connect to a SQL 2005 instance through Windows authentication. The client was written is VB 2005 and used OLEDB client acc ...Show All

• Jules Dcoder Integration services Globla variable and scheduling issue

  I have one main package from which i am executing 5 other packages.I want to use one single DB connection in all the packages which i am declaring in Main package and it should be available in all the child packages. How can i Do this Few Variables are common is all the packages so i want to keep it Globally so how can i access those variables How can i schedule package in sql server Thanks Hi Rafael Can we share Connections( Ole DB or FTP Comnnection) between packages Can you give one example of using parent package variable or if not possible, then please describe me the procedure. Thanks Priyank Gajera Priyank Gajera wrote: I have one main package from which i am executing 5 other p ...Show All

• Robert Hernandez Cannot transfer/copy database in one step like I could with 2000.

  Hi, I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems. I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer. I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step. I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want. I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error aski ...Show All

• Gilles Lafreniere FTP Task Fails - SSIS scheduled with SQL SERVER AGENT as JOB

  Hi, I have created a SSIS package and tested it in V.Stdio where it runs fine and uploads file on the remote server. Now I have scheduled it to run as a job in SQL SERVER AGENT as JOB, but it fails when it comes to the upload task I am quite sure as it is something with FTP connection string or security, but can't figure it out. I have simply added the IP/login/password in the connection manager for upload task. Any help/ guidance would be great. Thanks, Ad How is it possible to grant agent the right to use network Configuration Tools/SQL Server Configuration Manager Check if You use for the SQL Agent a domain or a User Account / and is this the same as t ...Show All

• Manolis Should be easy...Someone has to have done this already

  This may not be the right place for this post...but my head is hurting and I can't think right now. I have a SQL table of users. Each record has a required 'Birthdate' field. I'd like to order this by the days left till the give birthday, keeping in mind that the year may be 1980 or their birthday might have been 2 weeks ago. Can someone cure my headache Hmm, interesting question. I hadn't, and it was a bit tricky for me brain drop table person go create table person ( personId int, birthdate datetime ) go insert into person select 1,'20040120' union all select 1,'19800514' union all select 1,'19980301' union all select 1,'19780819' union all select 1,'19890203' go The basics are that want to look for the next date, ei ...Show All

• FernandoLeite Advice required: Matrix report with a static column

  First off, I apologize if this is an elementary question. Thanks for your patience. I have a requirement to develop a report that shows by calendar day how much effort a resource has expended on what tasks. So, I have a stored procedure that returns data that looks like this: Resource calendarDay description etcHours effortHours ------------- ------------- ----------- ---------- ----------- Smith, John 2006-08-01 Requirements 20.00 8.00 Smith, John 2006-08-02 Requirements 20.00 8.00 Smith, John 2006-08-03 Design 80.00 8.00 Doe, Jane 2006-08-01 Requirements 5.00 4.00 Doe, Jane 2006-08-01 Design 30.00 4.00 And I've developed a matrix report that looks like this: ...Show All

• Gravy Checkpoint restart

  I have a package that uses checkpoint restart. It is resposible for truncatings many sets of tables and then loading them. There are several ExecuteSQL tasks to truncate the tables and several corresponding data flows to accomplish the loads. If a load fails I want the corresponding truncate task to be part of the restart otherwise duplicate data may be loaded. Normally, SSIS will start at the failed task. I read something about containers that led me to think that if I put the truncate & matching load pair in a sequence container that the container would be the restart point, but either I read it wrong or it's not working that way. Anybody know how to accomplish what I want to do The contai ...Show All

• John Stearns Cannot connect w/ Java app but can connect w/ .Net app - SQL Server Express 2005

  I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005). The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running. SQL Server Express 2005 is installed in mixed mode. Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />. These are my values in my Java app web.xml - <init-param> <param-nam ...Show All

• Batikit SQL 2005 Standard error on Windows XP Pro SP2

  When I run the SQLSTD.EXE for the September CTP of SQL 2005 Std I get the following error message: "There is not enough space on drive C:\ to extract this package." I have over 13 GBs on C:\ and I've also uninstalled .NET 2 Beta 2. Anything else I need to do to successfully install this TIA I had this issue too. Very frustrating. Anyhow, just open the SQLEVAL.EXE using the open source extraction utility 7Zip (from 7-zip.org).. After installing 7Zip, right click on SQLEVAL.EXE and choose Open Archive. Then drag the contents of the archive out onto explorer somewhere, and run the server's setup.exe I am trying to extract the sqleval.exe file and also get ...Show All

• ChKa Merge replication downloading old data to the suscriber

  I'm having an error with merge replication my suscriber are downloading old data, all this start happen after I install SP4. let explaint this with more details , if a made an update to a row in a table from the publisher , the agent history show that 1 change have downloaded to the suscriber, a put an audit in the suscriber and yes one update was downloaded but the row still the same, look like the suscriber downloaded old data instead of the curent change that i made. If i delete the row, the rows gets delete at the suscriber, if a insert the row the row get insterted ok. The problem only happen with rows inserted at the suscriber, that later on get update at the publisher. My suscriber has MSDE 2000 SP3 an my Server has SQL ...Show All

• fatalist How to access to an another database?

  Hello, I 'm making a procedure that needs to use a table that is in an other database and that database is in an other SQL Server Group. Did you know if is it possible. How can I make this Thank you very much for your help and time. Jonathan. yes u can do this...add the other server as a linked server to ur server..using sp_addlinkedserver... then refer the table in other db as servername.dbname.dbo.tablename eg. select * from server1.mydb.dbo.table1 Thank you very much, Nithin Khurana!!!! Jonathan ...Show All

• Scott1234567 MDX Query never finishes

  I am populating flatfiles from MDX queries run i SSIS against AS databases. I have ran in to problems with MDX queries returning large resultsets that never finishes. The query performed is purchase calculations over different time periods for each member in the customer dimension. There are 6-8 calculated members created and the customer dimension contains about 3,5 million members. When query is run, after 1-2 hours the server stop allocating memory and starts to get data from cache in intervals. In the end of each interval, memory is dropped. In perfmon it seems to be no activity during long periods I have given it as long as over 3 days without any result. Server is 8 x 64bit cpu with 16 gig memory. Some help in this ...Show All