Excel Column Disappear
Oct 7, 2015
I have questions regarding SQL 2008 r2 and Excel 2013.The below code users run from excel and it display all the data first time and when user click refresh under Data in excel the JOBID under JOB column disappear but all other column does not.
SELECT Ind_DHK_ProdRpt_view.Job, Ind_DHK_ProdRpt_view.suffix, Ind_DHK_ProdRpt_view.item, Ind_DHK_ProdRpt_view.description,
Ind_DHK_ProdRpt_view.qty_released, Ind_DHK_ProdRpt_view.[Current WC], Ind_DHK_ProdRpt_view.EndDate, dt.trans_Date AS IntoQue,
Ind_DHK_ProdRpt_view.co_num, Ind_DHK_ProdRpt_view.Bill_Name, Ind_DHK_ProdRpt_view.UsedHrs, Ind_DHK_ProdRpt_view.start_date,
[code]....
View 0 Replies
ADVERTISEMENT
Oct 10, 2007
I install add-in and run fine for a while, then all of sudden I could not see Table Analyze tool and data mining tab at my ribbon. I re-run server configuration and re-connect to DMAddinDB (remote server, but I am the administrator), but data mining add-in and table analyzer still not showing at my ribbon.
Then I uninstall DMAddin, re-install it, go through configuration again, but still the tabs are not showing up.
Any idea you can help me get my add in back?
View 12 Replies
View Related
Jun 3, 2006
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.
View 4 Replies
View Related
Jun 14, 2006
l've the following situation,
l've some excel files controlled by Vendor which changing frequently. The only thing does not change is the header name of each column.
So my question is, is there any way to create a new table based on the excel file selected including the column name in SSIS? So that l can use the data reader as source to select those columns l am interested on and start the integration.
Thanks.
Regards,
Yong Boon, Lim
p/s : The excel header is at the row 7.
View 3 Replies
View Related
Jul 6, 2015
While importing data from Excel source , some column is getting null value even though excel column has value.To Resolve the issue we tried with
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice14.0Access Connectivity EngineEnginesExcel
1.Change the Value of the Row TypeGuessRows from 8 (Default value) to 0 and ImportMixedType = text
• xls
HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesExcel
1.Change the Value of the Row TypeGuessRows from 8 (Default value) to 0 and ImportMixedType = text
the connection string of the excel
UPPER(REVERSE(SUBSTRING( REVERSE(@[User::VarInputExcelFile]), 1, 5) ) ) == ".XLSX" ? "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::VarInputExcelFile] + ";Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";":"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + @[User::VarInputExcelFile] + ";Extended Properties="EXCEL 8.0;HDR=Yes;IMEX=1";"
by doing the above setting also , the column is coming as null from excel source even though there is data in excel.
View 2 Replies
View Related
Feb 12, 2007
Is it not possible to execute one package and then design another package? I am executing one package and trying to design another package and just have a grey window in the control tool box that says:
"there are no usable controls in this group. Drag an item onto this text to add it to the toolbar"
Can I only get my controls by dragging when another package is executing? Where do I drag them from?
Thanks,
Kayda
View 4 Replies
View Related
Dec 21, 2006
Hallo all :
How to disappear the generic bar in the report, or to disappear some options (example export). I speak about the bar which in the top of the report or there are the numbers of pages.
Thank's.
View 4 Replies
View Related
Feb 17, 2004
I created a new database role to give a number of users select privilege only on some tables and every day I have to go back in and add the tables back to the role. Is there something I'm missing here?
View 8 Replies
View Related
Jul 20, 2005
I has a strange question.My company is using a old system with Win NT 4.0 Server + MS SQL 7.0.The system is busy and handle a lot of SELECTs and INSERTs all the time.Sometimes, some transactions are blocked by some other transactions.For those INSERT transactions, we usually call a stored procedure and passparameters in to do the INSERT, at the end of the INSERT stored procedure,we always check @@ERROR = 0 and retrieve the @@IDENTITY (it is usually theauto number primary key) to confirm the INSERT is success. But the strangethings is, sometimes, @@ERROR is equals to 0 and I can get a value from@@IDENTITY but when I fetch the record by the primary key (the value of@@IDENTITY) it returns nothing!! The record is disappear and the primarykey is skipped! I found that this happens usually when the INSERT executeat the time when some other transactions are blocking. Anyone knows why therecord is disappear while @ERROR = 0 and the stored procedure can returnvalue from @@IDENTITY?? Anyone has such case happen in their server aswell? Please tell me some solutions on how to solve this, thank you x10000000 times.
View 10 Replies
View Related
Nov 28, 2007
Hello.
I have a parameter with multi value option.
When I run the report in Visual studio, The first value in the drop down of this parameter is (Select All).
When I check this option it check all the other values for this parameter and when I unCheck this value it uncheck all the ther values for this parameter.
The problem is thet when I'm publishing the report to the server and then open it in IE the (Select All) value does't appear and I only get all the other values.
Any body know how to fix this?
Thanks.
View 5 Replies
View Related
Jan 8, 2007
Hi:
Did you have any experience that all publications and their related jobs suddenly disappear?
I had a transactional pull replication between two servers, and distributor and subscriber in the same box; publisher was an AA cluster server.
The schedule of pulling was once a week.
Last Friday morning everything was working perfectly, but I found all publications and their related jobs disappear around 5pm
I checked with the sysadmin and he said nothing was changed on that period.
Did you have any idea about it?
Did you have any idea that I can prevent this happen again or any alert I can set up to monitor who drop it, when it was dropped and so on?
It is a SQL 2000 box and system table doest not take trigger.
Thanks in advance
Theresa
View 2 Replies
View Related
Dec 27, 2007
I just got a new computer (it is running XP) and after installing Visual Studio 2005 and then SQL Server 2005, If I open up an existing SSIS package the lines around the components are missing. If I click on the component and then click off the line reappears. Has anyone experienced a similare issue?
View 1 Replies
View Related
Mar 11, 2008
Hi,
I am presenting some data fields value in the Page footer by using the referencing trick to textbox, exist in the body of the report.
Now the problem is while running localy i am getting all the field values as I want, but while exporting into PDF or printing the report I cant see those values in the footer.
while running the same report from report manager the arrangments of the textboxes in the footer got displaced.
Any help will be highly appreciated
Thanks
View 4 Replies
View Related
Dec 19, 2006
Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.
Is there some security setting that hides the variables and their values which is on by default?
View 1 Replies
View Related
Jun 17, 2015
I have a few SQL instances on my server (jdjfdijdk)
They where called and organized like this:
MyServer - Database1
MyServer/BBserver - Database2
For some reason instance MyServer/BBserver has stopped and I couldn't make it start so I decided to reboot the server. After reboot the MyServer/BBserver was working but when open the other instance MyServer using Management Studio the Database1 disappear and the Database2 can be accessed by MyServer/BBserver and MyServer instances.
Even a backup made of Database1 and stored at
C:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLBackup vanished.
How to recover Database1?
View 19 Replies
View Related
Nov 27, 2007
Hi,
On a report I have a textbox. When a user prints the report I don't want the textbox printing. Does anyone know any code which will set the visibility of the textbox to False when printing??
View 1 Replies
View Related
Jul 20, 2005
Hello,What could possibly cause data in the SQL server database to beremoved, except being deleted manually? We had a couple of situationswhere data in certain records disappeared although the records werestill there. The data is entered and editted through the web interfacein ASP. The web interface is accessed by anyone who has an account inour database.I am more of a web programmer, not a SQL server administrator, so notvery familiar with SQL Server log or error tracking. If you cansuggest any way to track this kind of events (data disappearing), Iwould appreciate it very much.HB Kim
View 10 Replies
View Related
Jun 14, 2006
Guys,
anyone seen this before?
I've just finished me lovely big package.. decided to tidy it up and make it look nice...
(when will I ever learn?)
So I selected a few tasks, right clicked and selected "group". Named the group.....
And now all the connectors between the tasks in the group have disappeared.... tried ungrouping.. still not there...
The package still runs fine... the tasks are executed in the right sequence and all that... but the connectors are jut not visible...
If I try to recreate the connector I get an error dialog saying "Cannot create connector. Only one workflow can exist between the same two executeables.". So they must still exist...
It'd be ok to leave it as it is I suppose.. if I didn't now need to modify the precedence constraint on one of the connectors.... and I can't actually select the feckin connector..
Any suggestions? Any way to refresh the display? Have already exited the environment and come back in.. will try rebooting machine now anyway...
PJ
View 4 Replies
View Related
Mar 24, 2008
Follow-up to:
http://forums.asp.net/t/1237676.aspx
The update command seems to be deleting my data. If I set the Parameter "DefaultValue" to "NULL" then it updates that field to the literal string: NULL
WTH
Nick
<UpdateParameters>
<asp:Parameter Name="DevelopmentArea" Type="String"/>
<asp:Parameter Name="DevelopmentGoals" Type="String" />
<asp:Parameter Name="DevelopmentPlans" Type="String" />
<asp:Parameter Name="CurrentStatus" Type="String" />
<asp:Parameter Name="FutureState" Type="String" />
<asp:Parameter Name="DetermineFactor" Type="String"/>
<asp:Parameter Name="MentorRequested" Type="Boolean" DefaultValue="False"/>
<asp:Parameter Name="MentorList" Type="String"/>
<asp:Parameter Name="CheckPointDate" Type="DateTime" />
<asp:Parameter Name="DateUpdated" Type="DateTime" />
<asp:Parameter Name="PlanPKID" Type="Int32" />
</UpdateParameters>
View 6 Replies
View Related
Jun 5, 2007
Hi,
anyone has any idea how to make the parameters toolbar to be automatically hidden when the report is first being accessed and subsequently to show the parameters when clicked on the arrows ? I have some users who complained that the parameters list is too long, so they wish to hide it first when accessing the report. I know there's this called rc: Parameters=false but this will permanently hide the toolbar which i don't want.
By the way, i am using sql 2000 reporting services
View 1 Replies
View Related
Feb 1, 2007
I have scoured the internet looking for someone who has run into this issue with no such luck!
Product: Reporting Services 2005 Analysis Services 2005
Our users use Report Builder as an ad-hoc report tool. Data sources for Report Builder come from Report Servers and Analysis Servers.
I have run into issues where a user will select a source for their report that is based on an AS cube. When they select an attribute (field) from a selected entity in the Report Builder Explorer and drop it on the canvas, all entities except the one the field was selected from disappear.
For example:
A cube has a fact table called "Annual Income" with dimension of employee and demographics. In Report Builder, the entities would be listed in the left hand Report Builder Explorer window as
Annual Income
Employee
Demographics
If I select attributes from Employee or Annual Income, as usual, you will see the related hierarchies of the remaining entities. However, if I select an attribute from Demographics, then the Annual Income and Employee entities just disappear and all I can see is the Demographics entity and its attributes.
Has anyone run into this and if so, any ideas? This is becoming extremely frustrating. I have deleted and rebuild cubes, individual dimensions, and everything else I can think of.
Your responses are appreciated,
Scott
View 1 Replies
View Related
Aug 16, 2007
We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.
SQL Express Response
.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;
MSDE Response
...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser
verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server
Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;
Any ideas?
Thanks, Kevin.
View 2 Replies
View Related
Aug 16, 2007
We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.
SQL Express Response
.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;
MSDE Response
...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser
verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server
Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;
Any ideas?
Thanks, Kevin.
View 4 Replies
View Related
May 21, 2013
My company is new to MDS. I am trying to set an attritube in an entity to read only so the users can't change the value in that field. When I did that, the whole model disappeared. I thought I had deleted it by accident so I created a test model and tried to do the same. The test model disappeared. This time, before saving the new settings I took a snapshot. After saving I took another snapshot. You can see that the whole model is gone (zz_RN_Permissions_Test). I tried every other coworker with admin rights and nobody shows it on the Models list. The behavior on the Excel add-in is correct. I can't change any values on that column. But I need to keep the models available.
See before and after snapshots below.
View 8 Replies
View Related
May 11, 2006
im trying to access data in an excel spreadsheet using excel source component...the excel column is type of general and most of the data is numeric, some string..now, when ii hit the preview button, the string data would show up as NULL and the numeric data are correct...i've changed the excel column to TEXT data type and same result, how can i get the string data from this column?
View 1 Replies
View Related
Oct 31, 2006
Hi,
I have an excel export with numeric values. When the SSIS package writes into the excel it treats all data types as strings and attaches an apostrophe in the beginning. I tried formatting the excel sheet with the number data type and saving it . It doesnt work.
Other strange thing is that when I go into the advanced editor for the excel destination and look into the properties of the external columns all of them have the data type as Unicode String[DT_WSTR] irrespective of what the data type is from the input.The UI allows me to change it to numeric for numeric columns without any error but the value is not saved at all which is very frustrating. I also tried changing it in the xml file of the package, it some how seems to overwrite it after validation. It would be really nice if it threw an error saying that it cannot be changed.
Anyways there seems to be no way of changing the destination data type if it s an existing file and if I create a new excel sheet there is no way of formatting data. Is there any way out?
Thanks
View 6 Replies
View Related
May 23, 2008
Hi all, need help before i break this pc! trying to get an import job to read from an excel file. Normally this works fine, no issues but have a certain excel file that is just not importing correctly. one row is importing nulls for some values but without any visible reason. I have a file with over 15000 rows. 9 columns. last column stores a year in the format yyyy. this is the problem column. in the import job it shows up as a float. have checked the format of the cell and it says General in the excel file. when i execute the job over 5000 row come throught with null Years. cant see a reason for this. anyone able to shed some light please..
N.
View 3 Replies
View Related
Dec 10, 2013
I use bcp command to output to excel, it works. But I want to format the excel, some column width are too small,user need adjust the column width, otherwise it shows ######.
How can I set columns width when I use bcp output to excel.
Also, can bcp command output to multiple excel sheets and add report title in each excel sheet?
View 2 Replies
View Related
Feb 8, 2008
i've posted in the wrong forum, so im posting here
hi, im having problems to import data from my excel to a sql table.
in the excel file i have exact the same fields that i have in the table excepts the primary key which is an auto increment. When i try to import data, an error that i can't insert nulls into my auto increment column.
I put enable identity insert in the edit options, but still doesnt work.
can anyone help?
thanks in advance
View 1 Replies
View Related
Jan 30, 2015
I have a request to export some table data to excel and the "notes" column (varchar 255) contains multiple lines separated by CR/LF. when I export to excel, the first record with CR/LF messes up the column alignment in excel, throwing off the format from that point on. how can i export to excel so that it preserves these CR/LF. or if not, how can I remove these characters so that excel can handle it?
See attached example
View 3 Replies
View Related
Feb 4, 2015
Until SSMS 2012 I copy and paste grid view with header directly to Excel. Problem starts when I try to copy results from SSMS 2012 because text column copy with some format and spreads around sheet and not in only one cell. What do I have to do how to select text columns and how to copy them to excel. IN SSMS 2008 it all works OK.
View 3 Replies
View Related
May 9, 2008
Two issues,
1. Even if there is no text entered in the search box of the report viewer header, the next button is clickable and returns the message "the entire report is searched'. Is this a defect in the product?
2. When report is exported to excel, the excel object tries to keep the report formatting to the closest and hence merging the columns in the excel. What is the work around to fix this issue. The end users after exporting to excel would normally do a sort by ascending/descending on required columns and this behaviour is causing an issue.
View 1 Replies
View Related
Aug 23, 2007
Hi, there,
When I view the report on the web, everything is fine until I exported the report to Excel. Additional column and row without heading appear in the exported Excel report. I have no idea, where do these row and column come from as I don't have these additional row and column in the designer. These additional row and column contain the subtotal.
How do I get rid of these additional row and column?
Thank you.
Regards,
Yong Hwee
View 3 Replies
View Related
