Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Refresh SSIS Pkg To Get The Change


Hi, all,

How do you refresh a SSIS pkg to get the latest table schema change?

I have this data flow task that will load data from a flat file into a table.

I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20.

Then I went into Management Studio and changed the column size.
Now in my dev BID I got next:
[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection.

I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.

Thanks!


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Refresh SSIS Pkg To Get The Change
Hi, all,

How do you refresh a SSIS pkg to get the latest table schema change?

I have this data flow task that will load data from a flat file into a table.

I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20.

Then I went into Management Studio and changed the column size.
Now in my dev BID I got next:
[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection.

I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.

Thanks!

View Replies !   View Related
ReportViewer (web Control) - Parameter Change Refresh
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.



Is this possible?



Regards Andreas

View Replies !   View Related
SSIS Package Refresh
Hi, I have a little problem with an xml package.

I'm a newbie in the XML field and in the new features of SSIS....so help me!

I want to import a complex xml file in SQL Server via SSIS; I've created a package that map the xml source files to many different destination table. When I try to execute the package, I've one error about data type specified on XSD (for example unsignedShort instead of unsignedLong). At this point I fix the XSD file, settings the correct data type, but I don't find a way to explain to the package that it have to reload the xsd file. The only way is to make a new package....

I'm looking for a way to refresh the package without rebuild it...

many thanks

lavez

View Replies !   View Related
SSIS Refresh Fails
When I use the OLB data source (SQL SERVER 2005), select * from tableA, then
use several steps and then Union ALL and Fuzzy Match, the process works
fine.† When I change the data source SQL to include two tables with a cross
join, the new fields in Table B do not appear in the Union ALL or Fuzzy
Match steps but do appear in all steps prior. The advanced editor refresh
does not fix the problem.† Deleting and recreating the Union ALL shows the
Table A and Table B fields.† Fuzzy Match is still incorrect. Deleting and
recreating Fuzzy Match fixes it.

View Replies !   View Related
How To Refresh Access Table From SSIS Package?
Hi all,
I have created an SSIS package to export rows of data from SQL to Access using SSIS package. The package is executed from asp.net web application. Below is what i want to achieve:
-User enters a date range
-SSIS package will export data between the date range from SQL to Access database.
-When user enter another date range, I want to clear the contents of the Access database. (Im using Execute Sql Task--- Delete tablename)
The problem is that when I look at the table after the second user request, the fields will show #deleted. Only after i click refresh will the new data appear. How can I make the data appear without manually refreshing the Access table.
 Thks alot.

View Replies !   View Related
How To &&"refresh&&" Transformation In SQL2005 SSIS (I'm Trying To Transfer Random Sql Table Into Dbf)
Im from Russia, sorry if my english is not very good.

Here's the case:

1)-------------------------------
I made a DTS-package in sql2000 that transfers† the [sql table]† into [dbf file] via jet4.
First i create (in delphi) the empty dbf with the same name and columns same as in sql table.
Second, I run my DTS with variables - source and destination† table names

In DTS there is source, destination and† transformation . After I send the Variables(table names)
, the transformation "arrow" needs to be "refreshed" to make column names in both tables correspond each other.† For that in transformation I chose ActiveXScript Mode and wright VB Script:

'**********************************************************************
' Visual Basic Transformation Script
'************************************************************************

' Copy each source column to the destination column
Function Main()

dim i

For i = 1 To DTSSource.Count
DTSDestination(i) = DTSSource(i)
next

Main = DTSTransformStat_OK
End Function

And it works

2)------------------------------
I want to do same thing in sql2005 SSIS but don't figure out how...
I managed to make a package that recieves (in variables) table names and runs correctly.
But after I change those variable names into any other it crashes -
Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

Of cource this happens 'cause I didn't "refresh" the transformatoin (and maybe also source and dest), but I don't know how.

Anyone can help ?!

View Replies !   View Related
Change SSIS File
Hi,

i've been asked to move our ssis project to another machine
and i've a lot of file system connection whice i must rename them to the new path in the other machine.
there is away to rename the file system connection dynamic or i must go and rename one by one ??
thanks.

View Replies !   View Related
How To Change Xml With Xslt In Ssis
Hi,

I've got a problem with my ssis package.
I have a webservice, which from i am downloading xml file which looks like this:









Code Snippet

<?xml version="1.0" encoding="utf-16"?>
<DataSet>
† <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
††† <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
††††† <xs:complexType>
††††††† <xs:choice minOccurs="0" maxOccurs="unbounded">
††††††††† <xs:element name="Table">
††††††††††† <xs:complexType>
††††††††††††† <xs:sequence>
††††††††††††††† <xs:element name="lukas_id_nagrody" type="xs:string" minOccurs="0" />
††††††††††††††† <xs:element name="ilosc" type="xs:int" minOccurs="0" />
††††††††††††† </xs:sequence>
††††††††††† </xs:complexType>
††††††††† </xs:element>
††††††† </xs:choice>
††††† </xs:complexType>
††† </xs:element>
† </xs:schema>
† <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
††† <NewDataSet>
††††† <Table diffgr:id="Table1" msdata:rowOrder="0">
††††††† <lukas_id_nagrody>10</lukas_id_nagrody>
††††††† <ilosc>4</ilosc>
††††† </Table>
††††† <Table diffgr:id="Table2" msdata:rowOrder="1">
††††††† <lukas_id_nagrody>12</lukas_id_nagrody>
††††††† <ilosc>10</ilosc>
††††† </Table>
††††† <Table diffgr:id="Table3" msdata:rowOrder="2">
††††††† <lukas_id_nagrody>21</lukas_id_nagrody>
††††††† <ilosc>32</ilosc>
††††† </Table>
††††† <Table diffgr:id="Table4" msdata:rowOrder="3">
††††††† <lukas_id_nagrody>32</lukas_id_nagrody>
††††††† <ilosc>13</ilosc>
††††† </Table>
††††† <Table diffgr:id="Table5" msdata:rowOrder="4">
††††††† <lukas_id_nagrody>33</lukas_id_nagrody>
††††††† <ilosc>15</ilosc>
††††† </Table>
††††† <Table diffgr:id="Table6" msdata:rowOrder="5">
††††††† <lukas_id_nagrody>34</lukas_id_nagrody>
††††††† <ilosc>2</ilosc>
††††† </Table>
††† </NewDataSet>
† </diffgr:diffgram>
</DataSet>

And i want it to looks like this:






Code Snippet

<?xml version="1.0" encoding="utf-16"?>
<DataSet>
††† <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
††† ††† <xs:element name="DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
††† ††† ††† <xs:complexType>
††† ††† ††† ††† <xs:choice minOccurs="0" maxOccurs="unbounded">
††† ††† ††† ††† ††† <xs:element name="Table">
††† ††† ††† ††† ††† ††† <xs:complexType>
††† ††† ††† ††† ††† ††† ††† <xs:sequence>
††† ††† ††† ††† ††† ††† ††† ††† <xs:element name="lukas_id_nagrody" type="xs:string" minOccurs="0" />
††† ††† ††† ††† ††† ††† ††† ††† <xs:element name="ilosc" type="xs:int" minOccurs="0" />
††† ††† ††† ††† ††† ††† ††† </xs:sequence>
††† ††† ††† ††† ††† ††† </xs:complexType>
††† ††† ††† ††† ††† </xs:element>
††† ††† ††† ††† </xs:choice>
††† ††† ††† </xs:complexType>
††† ††† </xs:element>
††† </xs:schema>
††† <Table id="Table1" rowOrder="0">
††† ††† <lukas_id_nagrody>J07Z0</lukas_id_nagrody>
††† ††† <ilosc>1</ilosc>
††† </Table>
††† <Table id="Table2" rowOrder="1">
††† ††† <lukas_id_nagrody>J08Z0</lukas_id_nagrody>
††† ††† <ilosc>1</ilosc>
††† </Table>
††† <Table id="Table3" rowOrder="2">
††† ††† <lukas_id_nagrody>J09Z0</lukas_id_nagrody>
††† ††† <ilosc>1</ilosc>
††† </Table>
</DataSet>

Can You help me?

Thanks in advance

ps. sorry for my english

View Replies !   View Related
Change Ssis Connection.
Hi,



i have SSIS proj whice now it connect to server†A (whice is our test server)



now i want to modified our project that when we want it'll connect to server B (Our Prod server).



now i'm looking for something global that will switch the connection strings whenever i want.



what i find so far is to declare var for each package and give the var default value and to create script to change the value of the var.



is there a solution that will be for all the project and i don't have to change each package (i have alot of pckgs).



Thanks in advanced.

View Replies !   View Related
SSIS: Cannot Change Authentication From Win Auth
Full subject line would be "Integration Services: cannot change the Authentication from Windows Authentication"

"Why is it that when connecting to Integration Services I cannot change the Authentication from Windows Authentication? I have created specific SQL Logins to allow programmers to work with the database but they are unable to work with Integration Services."

EDIT: this question comes from the System Administrator of my SQL Server 2005. We are trying to get to the point where I can see and work with SSIS packages in SQL Server Business Intelligence Development Studio.

2nd EDIT: as far as acronyms used on this forum, is it acceptable to "short" SQL Server Business Intelligence Development Studio to SQL Server BIDS?

View Replies !   View Related
Change The Mappings In SSIS Packages
Hi,

My need is to load data from flat files to SQL tables. All the flat files are different. For convenience flat file name and table name is similar.
I have placed a For loop container and in which I used SCRIPT TASK to read the file names from the specified folder and i populated this value to SSIS variable. All my flat file name and destination table name are given using this Script task. For the first run it executes perfectly, but for the second run it fails. The reason is due to the flat file connection manager. The file name is changed since it is taken care by my script, but the columns are not mapped it still have the previous file's columns. I do not know how to solve this.

Please tell me if there is any other way to solve this or i need to refine my process.

Actually i have more than 100 files and so i am trying to do it at one short rather than creating individual packages.




Sarvan

View Replies !   View Related
CDS ( Change Data Capture) In SSIS
†Is there a built in functionality to †do the CDS in SSIS 2005? if not, what is the best way to do this in ssis 2005?

View Replies !   View Related
SSIS - Change Data Organisation
Hi,

here is my problem
i've a table in my database like this

Col1 | Col 2
____|______
aaa | 111
aaa | 222
aaa | 333
bbb | 222
bbb | 333


to insert data into a flat text file or another table
i would like to make a dataset like that :

Col1| Col2| Col3 | Col4
____|____|_____|_____
aaa | 111 | 222 | 333
bbb | 222 | 333 | NULL

the table is quite big, so i can't make it line by line

i would like to have a maximum of 12 column ( if there is more data than 12, these data should be ignored )

thanks for answering

View Replies !   View Related
Cannot Change SSIS Installation Directory.
Hi There

I installed Sql Server 2005 and SSIS to the C: drive of a server.

However i am going to install 3 more instances on this server and i want to install SSIS on the RAID drive.

So i uninstalled SSIS, then i installed another Sql Server instance on the D drive.

Now when i try to install SSIS, when i go to advanced and browse for installation path it is greyed out and it says that the path has already been bound to the 90DTS folder of the first instance i installed on the C: drive, so basically i dont know how i can install SSIS to another drive ???

Please help.

Thanx

View Replies !   View Related
How To Change Col. Dynamically SSIS UNPIVOT TASK
Dear All,

We are using UnPivot task to convert the columns into rows using the Excel File as source. But the Excel file column names are changing frequenly sometimes its having only 4 columns sometimes its 10 columns.

Everytime we are checking and unchecking the column list in Unpivot Task.

can anybody help us to solve this issue that Unpivot task should take the column name dynamically.

Thanks,
Syed

View Replies !   View Related
Is It Possible To Change The Local File Name Through The FTP Task In SSIS?
Hi, I have just started using SSIS and i was wondering weather I am able to change the file name as i am bringing the file in from the remote server through the FTP task. What i actually would like to do is append the current date to the end of the file name. For example if i was transfering the file test.txt, can i use the FTP task provided (and how would i do it) to store the file as testdate.txt?

Thanks in advance for any help provided

View Replies !   View Related
Dynamically Change SSIS For Each Loop Container
Hello,

I would like to modify "Files" attribute of the Foreach Loop of type File
Enumerator.  This attribute is used to set the mask (for example *.txt) to
specify which files to include in the selection.  I need to be able to change
this mask dynamically depending on package global variable.  Is this possible?

Thank you!

Michael

View Replies !   View Related
Change SSIS File System Connection
Hi,

i've been asked to move our ssis project to another machine
and i've a lot of file system connection whice i must rename them to the new path in the other machine.
there is away to rename the file system connection dynamic or i must go and rename one by one ??
thanks.

View Replies !   View Related
Howto Change The Value Of The ProtectionLevel Property Of A SSIS Package?
I see various references to the options for a package's protection level (including http://msdn2.microsoft.com/en-us/library/ms141747.aspx) but I can't seem to find anything telling me how to actually look at and/or change the protection level of a package - thus my question is "How do I change the protection level of an SSIS package?"



Thanks!



- Lance

View Replies !   View Related
Change Or Check Format Of Excel's Cells In SSIS


I load data from excel and sometimes I have problem with format of excel's cells. For example format of cell should be "general" but one of cell is "custom" and I get wrong data but if I just change format in excel to "general" - data is correct.
Can I change or check format of cells in SSIS ?

View Replies !   View Related
How Should I Change The Source File Name Every Time During Dataflow Task Using Ssis
Hi,
††† I am using SQL Server2005 for SSIS. I want to change the source connection dynamicaly evertime.
Let me clear, I have to extract some column from excel to MS-Access. I am using Data Flow Task and able to successfully complete the job. But problem is that, whenever a new file comes , i must have to reconfigure my Excel Source.
All the time column in file are same, so no need to worry about mapping but how can my package select a file automatically.
I have a directory, suppose "C:dpak". I should able to pick the filename and sheet name from this directory every time when my package will execute.

View Replies !   View Related
How Do You Implement Change Data Capture In SSIS Or SQL Server 2005?


Hi All,
I am now working on the design phase of my project, we are looking to implement Change Data Capture (CDC) but i need some help if you guys has implemented before using the SSIS 2005†componets. I am trying to use the Following:

Source---------Derived Column---------Lookup---------------Conditional Split (to split New records and Updated Records)-----------Destination. Respectively.
Lets make it clear, my source holds (Old records and newly added or Updated records), the Derived Column is to Derive new columns called†Insert_Date and Update_Date. The Lookup i am Using is to look the Fact_Table(the Old Records) as Reference, and then based on this lookup i will split the records on timely based using the Conditional Split. My question is
1. Am i using the right components?
2. what consideration should i have to see to make it true (some Logics on the conditional split)?
3. Any script which helps in this strategy?
4. If you have a better idea please try to help me, i need you help badly.

Thank you,

SamiDC

View Replies !   View Related
How To Change The Target Table Name In SSIS Package(not Designed From Scratch But Was Migrated)
In Past, I created DTS package on 2000 version, that import TXT file into SQL 2000 table.

Now I migrated the DTS to DTSX (SSIS) package, and all is working fine. but I can not find how can I edit or modify the target table name in DTSX(SSIS) package in BI Studio.

can you some body help.

Thanks

View Replies !   View Related
SSIS Script Task Alters Package Variable, But Variable Does Not Change.
I'm working on an SSIS package that uses a vb.net script to grab some XML from a webservice (I'd explain why I'm not using a web service task here, but I'd just get angry), and I wish to then assign the XML string to a package variable which then gets sent along to a DataFlow Task that contains an XML Source that points at said variable. when I copy the XML string into the variable value in the script, if do a quickwatch on the variable (as in Dts.Variable("MyXML").value) it looks as though the new value has been copied to the variable, but when I step out of that task and look at the package explorer the variable is its original value.

I think the problem is that the dataflow XML source has a lock on the variable and so the script task isn't affecting it. Does anyone have any experience with this kind of problem, or know a workaround?

View Replies !   View Related
Is It Possible To Change Or Replace The Default Package Template Named New SSIS Package?
I would like to standardize SSIS development so that developers all start with the same basic template. I have set it up so it is an available template (†http://support.microsoft.com/kb/908018 ) but I would like it to be the default when a new project or package is created. Is this an option?

View Replies !   View Related
How To Change Windows Auth. To SQL Server Auth. In SSIS Packages
I had a few packages created with Windows Authentication which now needs to be migrated to run with SQL Server Authentication. I tried changing it in the connection managers but the packages failed to validate at the SCD transformations.For a few packages I had Configuration files for these packages where i tried to do it but it dint run giving the following Error Message:
[Connection manager "Target"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.† Source: "Microsoft SQL Native Client"† Hresult: 0x80040E4D† Description: "Login failed for user <<with my network id>>.".

[Execute SQL Task] Error: Failed to acquire connection "Target". Connection may not be configured correctly or you may not have the right permissions on this connection.

Target was the name of my connection.

View Replies !   View Related
Refresh SQL
Is there a simple way to refresh the data presented when in Enterprise Manager?

When I am in EM and expand the server, expand Management, Current Activities, and
Process Info, I would like to refresh the data as users disconnect and connect in realtime
and I sit with a 'snapshot'.

Mike

View Replies !   View Related
How To Refresh
sql2000

I have an existing data warehouse that is refreshed nightly from system1.

We will be moving to a new system2 1/1/06.
The old system1 will be phased out by the end of 2006.
Several tables on system2 will have different keys.

I have to move the data from both systems in the data warehouse.

Here's the issue.
I have to totaly refresh the data warehouse nightly.
Once system2 is phased out how do I keep the data from system1
and refresh only data from system2.

View Replies !   View Related
Nightly Refresh
Please help.I have Database A (Archived data), Database B (Transactional data).Both A and B do not have any timestamps in any tables.I need to bring A (only once because it is archived data) and B withonly differentials into Database C for reporting purposes.Currently C is cleared before loading B with differentials every nightand A is not loaded since it takes 15 hours to load.Now I want to bring A once and leave it and then bring B every nightwith differentials without clearing C.Please suggest some solutions.Thank You

View Replies !   View Related
How Do I Refresh A View?
You know how I mentioned before that I was working with a database with a (bunch of) view(s) that are defined like this...

CREATE VIEW MyView AS
SELECT * FROM ExampleTable

Well, after altering the underlying table I noticed that the view is not picking up the new columns which leads me to believe I need to refresh the view.

Is this possible, if so, how?
SS 2K

View Replies !   View Related
Refresh Data
I want refresh data de SQL Server, every certain time at night, but I want that it does only, automaticy.

In SQL sentencs or DTS
What I can do. Thanks

View Replies !   View Related
Automated Web DB Refresh
How does one effectively accomplish the nightly automated "refreshing" of the datasource for an online data-driven Web application without the site's users experiencing any associated errors or downtime? Is it possible to "overwrite" an online datasource if users are connected to it? During the transfer or refresh can one ensure that users do not submit queries against a temporarily "non-existent" datasource?

(For argument's sake, say this is a very busy site accessed by users worldwide, therefore there is no specific period of inactivity throughout any given 24 hr period. The datasource would be SQL Server.)

While I understand that in principle I can update the SQL database using DTS in Enterprise Manager without stopping the server, my nightly "refresh" potentially includes record inserts, updates, and deletions, almost necessitating a complete overwrite of the datasource.

All thoughts are much appreciated.

View Replies !   View Related
T-SQL Help For Refresh Database
I need to automate the refreshes of production data onto our development server, for which I need to create a script for getting the users and aliases on the development server. Can anyone help me with this script from the sysusers and sysalternates?

I am doing this because the users on production do not match with development. Their permissions are different too. So I capture the present permissions using this script and then refresh the development database with production dump and delete rows in sysusers and sysalternates. Then run this generated script to create the development users and aliases. Any help in this matter is really appreciated.

Thanks,
Puran

View Replies !   View Related
Refresh Question
I have a page that pulls back a certain number of recordsets and provides a link to the next set. Within the page each record contains fields that can be updated. I have no problems with the redirection/update on the first page of the recordset but when you update any of the subsequent page it refreshes back to the first page. How can I force it to refresh the current page that is being updated? Below is my code. I have only included what I 'think' is important. Let me know if more is needed. Thanks. - Sharon





numpages = rs.PageCount
numrecs = rs.RecordCount

If mypage > numpages Then mypage = numpages
If mypage < 1 Then mypage = 1

' This line sets the current page
rs.AbsolutePage = mypage


gsCommand = UCase(Trim(Request.QueryString("CMD")))
If Len(Trim(gsCommand)) = 0 Then
gsCommand = Normal
End If

Select Case gsCommand
Case "FlagActivate":
ActivateQS
Case "FlagInactivate":
InactivateQS
Case "Normal":
NormalDisplay
Case Else
NormalDisplay
End Select

---Sub NormalDisplay - displays recordsets that are written to the page ----


Sub ActivateQS
Activation = "UPDATE Membership SET QSActive=1 WHERE KEYID=" & Request.QueryString("Keyid") & ""
Set grs = conn.Execute(Activation)
Response.Write (Activation)
Response.Redirect "quickstart.asp?CMD=Normal"
'Response.Write("<meta http-equiv=""Refresh"" content=""1; URL=""quickstart.asp?CMD=Normal"">")
End Sub

Sub InactivateQS
Activation = "UPDATE Membership SET QSActive=0 WHERE KEYID=" & Request.QueryString("Keyid") & ""
Set grs = conn.Execute(Activation)
Response.Write (Activation)
Response.Redirect "quickstart.asp?CMD=Normal"
'Response.Write("<meta http-equiv=""Refresh"" content=""1; URL=""quickstart.asp?CMD=Normal"">")
End Sub

View Replies !   View Related
Refresh Issue
Our application is C++ and datbases are Sybase. We are 11.5.1 Sybase. Lately some of our clients have complained about data refresh problems. That if a user has made some changes within the application then these data changes are taking long time to reflect to other users in the system. We do have in our application processes to automatically refresh data for other users but for some odd reason it is not working properly. Also every day we run sp_recompile and sp_stat on the tables and stored procs. Any ideas or leads ?

Thanks
Gohar

View Replies !   View Related
RECOMPILE / REFRESH UDF?
Is there a way (command or stored procedure) to RECOMPILE or REFRESH a USER DEFINED FUNCTION? I can recompile SPs with sp_recompile and refresh views with sp_refreshView, but I could not find any way to refresh User-defined functions (some of them are like views, with parameters).

Environment: SQL 2005 SP2.


Thanks !

View Replies !   View Related
Metadata Refresh
-We are using SSIS packages for various kind of data load from excel source.
-If there are any change in the data type or format of excel, the package cries for the Metadata mismatch.
-During design time if you accept the metadata changes, all things work fine.

But in our case we have deployed the packages on Production Server, now the excel file format/data has changed. The packages are expecting a different metadata so they are not working at all.

Do you have any suggestions for the above problem?
Thanks, Vijay.

View Replies !   View Related
Metadata Refresh?
What do you do to address this:

[OLE DB Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "objectName1" needs to be updated in the external metadata column collection.

A corollary question:† what does right-clicking a package in Solution Explorer and clicking "Reload with Upgrade" do?

View Replies !   View Related
How To Refresh The Package Log


HI,
I have attached logs for my packages which runs for every one hour.
so, by end of the day the size of the logs is getting more.
I would like to refresh the log for every day or for each time that the package runs.
How to get it done.
Could you please help in this.

Thanks in advance.


View Replies !   View Related
Refresh Default Value
Hello,



I have report parameters B with default from query.

This query depend on other report parameters A that updates befor report parameter B.

While user open the report and update report parameter A, the report parameter B get default value with the right default value but when user change his selection in parameter A, the default†value in parameter B doesn't changed



Any idea ?

View Replies !   View Related
Refresh In WebPage


Hi all...

when i select the 1st parameter in the report(in webpage) ... then the complete page is getting auto refreshed...same is happening for all the parameter selection...is it not possible to stop it from refreshing....

simply to say i want to get data without refreshing...

few ppl suggested me to use AJAX control but as iam not much familliar with AJAY iam trying to find some other way...can u help me pls....

Roopesh Babu V



View Replies !   View Related
Dataset Will Not Refresh


Hi all,


I have spent the last couple of hours searching previous posts to see if this problem has been address before, but I was unable to find anything.

My problem is this... I use a stored procedure to populate my report. The stored procedure has recently been modified, and while I can see these updated fields when I run it through the Data tab, the list of available fields in the Dataset sidebar does not reflect the changes.

I have tried refreshing the Report Datasets multiple times. I have tried deleting the *.rdl.data file. I have tried removing the dataset in question and re-adding it. I have tried creating a new project altogether. I've tried restarting, etc.

I recognize that I can go in and add/remove fields to/from the dataset to make it match, but this feels like a temporary fix (it resets every time I modify another of the report's dataset).

It definitely seems as if this is being cached somewhere, but where? And how can I reset this? I would appreciate any help or guidance on this, as my forehead is pretty sore from banging it against this brick wall.

Cheers!

View Replies !   View Related
Refresh A Table
Can i referesh a open table?

The scenario is that i have two windows open... one is the table and the other is the query that modifies the same table. I was wondering if there is a way to refresh the table so that after i modify the table i don't have to close it and reopen it to verify the changes.

 

cheers

View Replies !   View Related
Gridview Refresh After Update
Hi All,
I am new to development of asp. I have an SQLDataSource set as the data source for a grid view.  When I click on the edit link in the Gridview, change the data, and click update, the old data  is still displayed in the row.
I found exact same issue as here -- http://forums.asp.net/thread/1217014.aspx
Solution in the above thread is to add this
            {                if (reader != null) reader.Close();            }            conn.Close();
How do I apply above solution in my situation ?
 
I am updating through stored procedure.and don't have code at background.  My code is
Datasource :
<asp:SqlDataSource
ID="ds"
runat="server"
ConnectionString="<%$ ConnectionStrings:ds %>"

CancelSelectOnNullParameter="False"
ProviderName="<%$ ConnectionStrings:ds.ProviderName%>"
UpdateCommand="usp_save"
UpdateCommandType="StoredProcedure"
EnableCaching="False">
 
<UpdateParameters>
<asp:Parameter Name="field1" Type="String" />
<asp:Parameter Name="field2" Type="String" />
<asp:Parameter Name="field3" Type="String" />
<asp:Parameter Name="field4" Type="String"/>
<asp:ControlParameter Name="field5" Type="String" ControlID = "label7" />
</UpdateParameters>
 

View Replies !   View Related
SqlDataSource Refresh Problem
Dear sirs:I have a Web Form with an SqlDataSource with a simple select statement, and a GridView control that is tied to it. There is a ComboBox (which provides the filter-command parameter) and a Submit button as well. When a selection is made (the first time) in the combo box and then the submit button is clicked, the Selecting Event for the SqlDataSource fires and the code works perfect.However, on subsequent "submits" with the button and selecting a different month from the combo box, I cannot get that event to fire again. What do I need to do to get this event to fire everytime the submit button is clicked and a new selection made from the drop down combo box; thus letting me know that new data is being fetched from the database?Here is the code for the SqlDataSource:<<asp:SqlDataSourceID = "sqlDataSourceG5WingRailCar" runat = "server" ConnectionString = "<%$ ConnectionStrings:oracleConnectionString %>"ProviderName = "<%$ ConnectionStrings:oracleConnectionString.ProviderName %>" SelectCommand = "select distinct to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,                            rh.movedescription ,                            ( mds.pct_util * count( rh.movedescription ) )                            from requesthistory rh                            inner join movehistory mh on rh.itd_number = mh.itd_number                            inner join movedescription mds on rh.movedescr_id = mds.movedescr_id                            where rh.movedescr_id = 1 AND mh.discrepancy_id = 25 AND EXTRACT(MONTH FROM mh.historydatetime) = :MONTH_ID                            group by to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,                                         rh.movedescription ,                                         mds.pct_util                            order by to_date( mh.historydatetime , 'DD-MM-YYYY' )" √∂nSelecting="sqlDataSourceG5WingRailCar_Selecting" ><<SelectParameters>><<asp:ControlParameter ControlID = "dropDownListMonth" Name = "MONTH_ID" PropertyName = "SelectedValue" >><</asp:ControlParameter>><</SelectParameters>> <</asp:SqlDataSource>>There really is no code for the Selecting Event, other than just capturing some text into a label when the event occurs (for testing purposes).Thanks

View Replies !   View Related
How Do You Refresh Menu When Using SqlSiteMapProvider
I followed an article which was recently published by Jeff Prosise in his "Wicked Code" column in MSDN magazine and I was able to make it work.My problem is that I do not know how to refresh the menu. If I add new record in the sitemap table what needs to happen to refresh the menu.  

View Replies !   View Related
Database Refresh Question
There's a sql server 2000 database that was created as a copy of another db, let's say db1 and copy_of_db1. db1 has been updated (structure and data) since copy_of_db1 was created, while copy_of_db1 has remained static. I now need to update copy_of_db1 to be in sync with db1 and use copy_of_db1 so I can drop db1. What would be the fastest and most efficient way to update copy_of_db1 to mirror the current db1?

View Replies !   View Related
Refresh Schema Error?
So I've created this sql 2k5 clr stored procedure in c# that returns a table in a matrix-type of format.  Depending on the parameter you pass in, the size of the matrix (ie the number of columns and number of rows in the resulting table) can change, however no matter what the parameter is It will always contain at least 3 columns that are static and never change. 
I've added a SqlDataSource to my form, and told it to call this stored procedure, set the parameter to come from a query parameter and tested it in the SqlDataSource wizard and everything runs great.  By passing in the default parameter value it will return an empty table with these three columns.
I drop a GridView control onto my page and tell it to use the specified SqlDataSource that I just added.  I want it to populate these three columns and then enable the AutoGenerateColumns property so that it will get the remaining columns. 
Problem:  Anytime I hit "Refresh Schema" on the GridView control I get an error:
"There was an error inferring the parameters of the stored procedure:""The stored procedure 'sp_getSomeSortOfMatrix' doesn't exist."
Puzzled by this particular error and the fact that my SqlDataSource test ran successfully in the wizard I decide to hit the "Refresh Schema" on the SqlDataSource object itself.  It too returns this same error.
I run my page as is, with the AutoGenerateColumns property set to true, and the page runs fine.I would however like to have more control over the static three columns that are always there.
Is this error a 'bug' or mearly an 'issue' or is it by design that all queries that return a varying number of columns depending on input return this "doesn't exist" error?

View Replies !   View Related
Refresh Table Adapters
How do I refresh a Table Adapter to reflect changes in SP or SQL statement?
I created a Table Adapter based on a SP.  I added a column to the SP (foo) which was added to the table adapter when I re-configured.  I next deleted foo in the SP but could not get the table adapter to reflect this change.  I then added a column (Foo) to the SP which was reflected in the table adapter.  Deleted it and could not get rid of foo and Foo in my table adapter.
Help!
Jay

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved