Answer Questions

• IreneSmith bcp import of decimal data (long)

  I am trying to import data from a flat file into a decimal(9,2) column. Here is the decimal data in each record of the flat file: 123456789 There is no decimal point in the field but last two positions represent the right of the decimal point, some fields have leading zeros) I have discovered the following format file (extract) appears to do the import and place the decimal properly in the table column (1234567.89). Note the table column number and name are the same: snip 11 SQLCHAR 0 7 "" 11 FieldName "" 12 SQLCHAR 0 2 "" 11 FieldName "" snip But bcp throws this error after a few seconds: snip C:\>bcp DatabeseName..Tablename ...Show All

• pbairoleto SSIS Auditing example

  Greetings SSIS friends, Do any of you guys have a link to a website with an example of how to create a solid audit system for SSIS packages Thanks for your suggestions in advance. Hi Darren, Excuse my ignorance but where do I get hold of this project REAL stuff Grab the Project REAL samples, they use a augmented logging based on built in stuff, with some extras. An easy example, that was designed for real use, excuse the pun. dreameR.78 wrote: Hi guys, To be honest with you, having read the white paper and various other articles on the web regarding data quality checks and package auditing, I find myself more confused than ever. I wouldn’t even know where to begin or how many tabl ...Show All

• lookup Can I use VB.NET 2003 with SQL Everywhere?

  Hi, Can I use VB.NET 2003 with SQL Everywhere on desktop Is it possible to create and populate data into .sdf with VB.NET 2003 Please advice, thank you very much. Best Regards, Gabriel I would like to know also... I am having problem with reference System.Data.SqlServerCe.dll Not valid assembly or COM component. VS 2003 C# Thanks No, SQL Mobile and SQL Everywhere require the 2.0 versions of .NET assemblies and Visual Studio 2005 (hence VB.NET 2005). Darren ...Show All

• matthew lyden SQL Server 2005 + Transaction Logs

  We are running SQL Server 2005 and we have various database maintenance plans setup to do backups 3 times daily and also do reorganization of database indexes and such. We also have a shrink setup to shrink the DB on Saturdays. We have a drive for the transaction logs that is 36 GB and SQL has most of this space allocated. We have been having problems running out of space on this drive even though we are doing shrinks and such. We have the DB set to auto grow, but the shrinking should keeping the file size down. Is there known problems with this Or what are we doing wrong It appears that out log files grow drastically when we do a reorganize of the database indexes. Should this be the case And if so ...Show All

• juergen.b R

  How do i replace that character in a derived column Some rows have that character in one or more columns. If i just write this column == "" Unknown : column where the character is inside "" (can't write it here) the task will just succes without ever doing anything. The output says something like "the dataflow task had no tasks.....", which seems like a bug. Download any one of the many free hex editors on the Internet and open up a line of your source in it. Use the hex editor to find the hex value of the character in question. Go from there in your replace function. hmm found out that its a char(2) character. select char ( 2 ) gives that character. Now how do you replace ch ...Show All

• DanO84 SSIS Deployment

  Hello, I would like to know how to set up the SSIS package with the DATABASE, SERVER NAME and Connection String into variables, so that I can change these parameters of the deployement, on another name of server and database (and connection string). Thanks a lot for your advices ! Marie-Therese basically you have to enable package configuration and then decide where those configurations are going to live. You can use a SQL Server table; XML file; environment variable or regestry key. Depending on what you decide; you will need to change the configuration values where thy reside (table, variable, xml file, etc) If you look for 'package configurations' in bol or the forums you will find a lot of reference material. Here is a sampl ...Show All

• nbrege Reporting Services 2005 - Security Extention

  Hi, I have compiled the security extension sample code that comes with the installation and I was able to successfully deploy it on the Reporting Server. Now my server asks me for username, password when browse to the http://servername/reports folder. I have configured one user as say "AdminUser". When I login as AdminUser, I am to see all my reports and browse thru them. I created one more user say "RegUser". I have logged in as AdminUser and I have give permissions to RegUser for some folders on report server. Until this point every thing just worked fine and absolutly no problems. The real problem shows up when the "RegUser" logs in to the system. He is able to login, but he cannot see any th ...Show All

• NewbieElliott Export DataBase from one Server to another distant server

  Hello , I would ask about the manner of exporting a data Base from one server to another server. Thanks in advance. Thanks , But I don't need a commercial link, what I need is just a tuotrial or something like that Maaloul wrote: Hello , I would ask about the manner of exporting a data Base from one server to another server. Thanks in advance. Try the import/export wizard. The best way to learn how to use it is not to follow a tutorial but to open it up and follow the wizard. just have a go. FYI: The link to Kirk's book is part of his signature, its not like he deliberately put it there to answer your question. -Jamie Use the c ...Show All

• Luis Esteban Valencia Muñoz rigid vs. flexible when doing full process

  Given the assumption that the cube is small enough that we'll always do a full process on the cube... Is it fair to say that there will not be a difference in MDX query performance depending upon whether all attribute relationships are rigid vs. flexible I know flexible vs. rigid impacts performance when incrementally processing dimensions. And I know it impacts aggs... as I understand it aggs involving flexible relationships are stored separately from aggs involving rigid relationships. I'm trying to validate whether aggs are stored less efficiently because of flexible relationships... and exactly what impact on query performance this will have. A question to Mosha. Why should we use rigid attribute relations If you are ...Show All

• Valery Zharkov Compare csv file layout to SQL Server table

  I am creating a facility whereby you can select a source file (.csv), and a target (SQL table). Then I call a DTS to copy the csv file to the SQL table. How can I validate that the two files have the same number of columns In order to check the number of rows you need to work on DTS with workflow, refer to books online for more information and you can schedule the DTS package a SQLagent job by right-click on selected package. I need to validate that the correct file has been selected before scheduling the DTS package. This is why I need to do it in my VB.Net Windows application. Moved to SQL Server Tools forum You can write a custom Script Task inside ...Show All

• Pi314159 Bookmarks (Management Studio)

  How do you save bookmarks so you can use them next time you edit the saved query file Bookmarks in Management Studio are consist with Visual Studio. To use bookmarks your files need to be part of a solution/project, rather than just loose files. Yes, the environment allows the creation of bookmarks on files that are not part of a solution but these bookmarks are not persisted. When you create a solution, add a file, create some bookmarks, the bookmarks will be persisted and show up each time the solution is opened. My files are part of a solution. When I open the solution the query files are displayed in the solution file. I add bookmark to the query files, save all the files, and then close the so ...Show All

• kenlefeb XML source drops data - can I fix in XSD?

  XML looks like this: < xml version="1.0" standalone="yes" > <hist key="ABC">      <r date="2006/04/21" time="08:53:04" seq="1029">123</r>      <r date="2006/04/21" time="09:21:40" seq="1613">123.25</r>      <r date="2006/04/21" time="09:37:22" seq="  89">194.21</r>      <r date="2006/04/21" time="09:37:22" seq="  91">194.21</r>      <r date="2006/04/21" time="09:37:22" seq="  93">194.22</r>      <r date="2006/04/21" time="09:37:22" seq="  95">194.22</r> </hist> In SSIS it reads all t ...Show All

• Madok Service Pack 1 -- account information could not be verified

  When installing Svcpack 1 ontop of my 9.00.1399.06 RTM Developer Edition I get the following error everytime: --------------------------- Invalid Login Information --------------------------- Your account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To proceed further deselect the instances to which connectivity cannot be established. --------------------------- OK   --------------------------- I have followed all possible suggestions on the following post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=358003&SiteID=1 but nothing works.  I'm running as the local admin on t ...Show All

• nightchaser Deployment and Configuration

  Hi: I have a SSIS package on my local machine, and would like to deploy it to DEV server. Which files should i be moving to the SQL DEV Server and where How do I modify connection managers or is there a way to do that from the Management Studio or some other way Thanks and I would definitely appreciate some prompt advise. I prefer to have my packages as File system files (.dtsx); then all I have to do is to move (copy the files) them into a folder in the server. I use SQL Server table based package configurations to change connection strings at run time (and any other required property). I know there is a Deployment wizard in BIDS but I have never looked into that; so you do the research. Some times I use the SET option in ...Show All

• Kanhaiya cursor select and variables

  I have problems to place my variable into the select statement. DECLARE @DB_NAME varchar ( 64 ) DECLARE MR_ReqPro_DB_cursor CURSOR FOR select name from dbo . sysdatabases where name like '%MR_req%' OPEN MR_ReqPro_DB_cursor FETCH NEXT FROM MR_ReqPro_DB_cursor INTO @DB_NAME WHILE @@FETCH_STATUS = 0 BEGIN print @DB_NAME ; --works fine Select NAME , FILEDIRECTORY FROM @DB_NAME . MR_ReqPro . RQDOCUMENTS WHERE ( FILEDIRECTORY LIKE '%\\%' ); FETCH NEXT FROM MR_ReqPro_DB_cursor INTO @DB_NAME END CLOSE MR_ReqPro_DB_cursor DEALLOCATE MR_ReqPro_DB_cursor GO How could i use a variable like @DB_Name in my select the object against which you run a query cannot b ...Show All