hi friends
In my form i am storing system's date in the database.
4 that i m using a variable of date like:
dim today as new date
today=now.date
but its storing the default date that is '1/1/1900'
how to overcome this problem?
Hi guys, I was doing some changes on my asp web pages, I added new field expiry date that will be scanned into the system in format ddmmyyyy but it can't save as i am gettting that message that char can't be converted into datetime as date time was out of range.
I have added this into my asp pages <% Session.LCID = 3081 %> and changed the sql server regional setting setting the date to dd/mm/yyyy I can't set it to ddmmyyyy as there is not option without "/".
Could somebody help me as this is quite frustrating.
Thanks
hi i have question
can sql server know when the row in table Saved CREATE TRIGGER date time on the ROW ?
add new field call "date_row_save" date+time
inside the the sql server
i need to know whan the row Saved
is it possible to do this in TRIGGER ?
TNX
This is a pretty simple question, but I'm going nuts trying to find the answer. After creating an SSI package, I told it to save to the SQL server... Now where do I go to pull that package up again and make changes and/or execute the package?
View 4 Replies View RelatedI'm in the midst both of developing and using a custom Transformation. Of course, every time I change the assembly version and reopen Visual Studio, I get the error:
DTS.Pipeline: The component metadata for "component "Map SERVICE_CERT String Locale" (195692)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Out of curiosity, I'm wondering, how did it fail? Did it throw an exception? Was it even called? Is it my PerformUpgrade override that is being referred to, or perhaps the base class version?
I've seen several of the threads on this topic in this forum, but they haven't completely solved the problem (I will take the step of creating a policy assembly later today, and maybe that's the problem).
But, is there a reference somewhere to exactly what's going on at package load time as far as loading custom components? I'd love to know which methods are called, in which order, and how SSIS decides which version of the component to load.
I'd also love to see some best practices for component development. For instance, maybe I shouldn't allow the assembly version to change during development? Do I need to remove and re-add the component from the toolbox, and does that affect components already in the package?
Sorry to ask questions I'd no doubt answer for myself within a few months, but this project is due at the end of this month!
I am looking for a script whichs exports data (by DTS?) into a flat file and store the files (according their date stamp in the transactions) with a name like 05_2002.txt, 06_2002.txt etc. The data in the table Transactions will be deleted after some time to prevent fast growing of this particular table.
Any idea?
Thanks
Mike
I started my database in last week to user with transfer data from Sybase to sql 2000 server. Intitally log file size was few MB near to 20 MB for each co’s, within 8 days it has reached upto 300 MB still datafile size in few MB , approximately 40MB for each co’s, why log file growing in such manger, how I can manage it?
Thanking You
R.Mall
Our current production deployments using merge replication are averaging 4-5 hours - all of which is downtime for our client sites. Hotfix releases require no downtime, I am talking about maintenance releases where articles are changed/added/removed requiring a full snapshot to be taken.Management is not happy about this deployment window lasting so long.I have two questions:1) Our first suggestion is to do a proof of concept of leaving the sites up while the snapshot is being generated and only briefly bringing them down as the snapshot is applied as leaving them down while we smoke test the new application + DB code. Is this easily accomplished of making SQL Server disconnect the taking of the snapshot with the application so we can time this appropriately?2) Our snapshots take ~45minutes and we have 3 snapshots that are typically required. We currently run these serially.A) Is there a way to take/apply these snapshots in parallel?B) We have a SAN on production and have the capability to do SAN replication. I am not too familiar with SAN replication, but can that somehow be used to make these snapshots run in minutes rather then closer to an hour?Any links/references that are informative for dealing with merge replication deployment best practices would be much appreciated as well.Thanks!-John
View 10 Replies View RelatedWe have a number of scheduled reports in our system. But frequently, I
need to kick off one or more of them immediately at random times - to
run off schedule, so to speak. The only way I know to do this is to
actually modify the schedule to set it to run "Once", set the time to
run to be a minute or so into the future, then wait for the report to
run. Afterwards, I go back into the scheduler and re-establish the
original schedule.
Do you know of a way to do this without having to modify and disturb
the original schedule?
Thanks,
Behzad
Picture tells all what i need. Anyway i want to combine upper two tables data like below result sets. Means they should be grouped by bsns_id and its description should be comma separated taken from 2nd table. In sql server 2012 ....
View 5 Replies View Relatedi want to combine upper two tables data like below result sets. Means they should be grouped by bsns_id and its description should be comma separated taken from 2nd table. In sql server 2012.
This is the image path :
[URL]
Can someone tell me where DTS Packages are saved by default? Is it the MSSQL7/Binn directory?
Thank you,
Michelle Turner
When I submit data through my website one particular field which is drop down field and has 4 values (5, 10, Fee, other) saves as "undefined"
I get no errors through the web site.
Field is varchar
I recently viewed an application which included customizable savable reports. In the first step, the user selects from a very large (probably over a hundred) set of variables to include in the report (these would be the columns displayed in the report). In a second step, the user selects (from the same set of variables) which variables they want to set as criteria indicators (these would then be dropdowns and text boxes on the report that would filter the query results).
So, how do they do this? Lets take the AdventureWorks database as an example. Lets say the user can select the following variables to include in their report:
Product.Name
Product.ProductNumber
Product.Color
Product.Size
Product.ListPrice
WorkOrder.StartDate
WorkOrder.EndDate
WorkOrder.OrderQty
PurchaseOrderDetail.DueDate
PurchaseOrderDetail.UnitPrice
PurchaseOrderDetail.OrderQty
Vendor.Name
Etc…
How do you design this in the database? If you have a table that holds all of the possible variables, and a table that connects the user-selected variables to the user – how then do you construct the query that pulls it all together? For example, what if a user wants only these two variables in their report:
Product.Name
Vendor.Name
Here is the query:
select p.name as ProductName, v.name as VendorName
from Production.Product as p
inner join Purchasing.ProductVendor as pv on pv.ProductID = p.ProductId
inner join Purchasing.Vendor as v on v.VendorId = pv.VendorId
How do you build that query from just getting two variable names?
ALTER TRIGGER Trigger1
ON countries
FOR UPDATE AS
begin
insert into country1 values(:deleted.cid,:deleted.cname,getdate(),,system_user,@@servername, host_id(),host_name(),DB_NAME())
--select * from country1
/*insert into country1
select * from deleted*/
i want to store data into country1 table as old data with all information
end
IF I WANT TO SAVE THE ABOVE TRIGGER ERROR OCCURS
IAM USING SQL SERVER 2005
HELP ME
Malathi Rao
I created a DTS by right clicking and exporting the data to a file and I also saved the DTS package. Where will the DTS Package be saved in SQL 2005 in case if I have to do any modifications later.
Thanks !
I don€™t understand what
my wrong is. I am trying to save data in to SQL Mobile Database. my Database is included in my project. after saved, i connect that database by VS2005 server explorer to view the data. But I don€™t found any data in Sdf file.
private void cmdSave_Click(object sender, EventArgs e)
{
SqlCeConnection objmycon = new SqlCeConnection(); objmycon.ConnectionString = ("Data Source =" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\SC.sdf;"));
SqlCeCommand objcmd = new SqlCeCommand();
objcmd.Connection = objmycon;
objcmd.CommandText = "Insert Into BenInfo (BenID, BenName, BenDOB, BenRegDate, BenExpDate) " +
" Values(@BenID, @BenName,@BenDOB,@BenRegDate,@BenExpDate)";
objcmd.Parameters.Add(new SqlCeParameter("@BenID", SqlDbType.NVarChar, 6));
objcmd.Parameters.Add(new SqlCeParameter("@BenName", SqlDbType.NVarChar, 50)); objcmd.Parameters.Add(new SqlCeParameter("@BenDOB", SqlDbType.DateTime, 8));
objcmd.Parameters.Add(new SqlCeParameter("@BenRegDate", SqlDbType.DateTime, 8));
objcmd.Parameters.Add(new SqlCeParameter("@BenExpDate", SqlDbType.DateTime, 8));
objcmd.Parameters["@BenID"].Value = this.txtID.Text;
objcmd.Parameters["@BenName"].Value = this.txtName.Text;
objcmd.Parameters["@BenDOB"].Value = this.dtpDOB.Text;
objcmd.Parameters["@BenRegDate"].Value = this.dtpRegDate.Text; objcmd.Parameters["@BenExpDate"].Value = this.dtpExpDate.Text;
objmycon.Open();
objcmd.ExecuteNonQuery();
MessageBox.Show("Beneficiary Information Save Successfully.");
objmycon.Close();
}
please advice me.. how can i over come this situation....
Hi!
I want to modify a package stored on the server from my client machine, and everything goes great.
The only problem I get is that when I try to run it by double-clicking it I have to re-write the password in the connection string, i.e. "pwd=asdasd", because it is not saved by the package itself even though the checkbox in the Connection Manager tab (in the SSIS Designer) is checked. What can I do to save it automatically??
Thanks
Hello All,
I am facing this unusual error. In My ASP Page I am submitting the Page and after submitting the form I am calling another ASP page, which contains sql command to insert the record.
My Problem is when I am submitting the Form. Record is getting inserted twice with same values.
What is the cause of this problem as I am facing this problem in every form.
With Regards
Sunil Dutt
Hi, there;
I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..."
Did I do something wrong or anybody know how to save that password field?
Cheers
Hi,I've got a question about saving into datetime fields in a SQL Server table. A form I have create has two fields both for dates as well as other form fields, but the user may or may not fill in all the form fields, so when they click the save link I have a query which saves all the form fields whether they are blank or not. Unfortunately this is causing the two date fields to be saved in the database as "01/01/1900" even thoough they are blank fields.What is a good way to not save blank date fields as "01/01/1900"?ThanksStephen
View 1 Replies View RelatedI have a developer using SQL 7.0 Enterprise Manager and the DTS Wizard to create and save simple DTS imports on the SQL Server. The DTS job runs only on his workstation using his NT logon ID. Server is set for mixed security.
Other users can edit the saved DTS job and resave it, then anyone can run the job. I tried having the developer log in with his NT logon ID on another workstation; he can't run the job from there if he was the last person to edit it from his workstation.
Any ideas, anyone? This is the only person having this problem in my shop.
Thanks!
I was trying to save a long text from asp.net application to "text" data type in sql database but it gets cut off at few hundred characters.
Does anyone know what the problem is?
Thanks for any help.
I have saved a DTS Package, in sql serv 2005. How do i run it ? I cant fiqure it out
View 5 Replies View RelatedI recently wrote a stored procedure to add the date and time to an existing table. The date is being stored as
Oct 29 2007 5:37PM
Instead of as
10/29/2007 5:37:23 PM
The column is a varchar(24) data type and I use GETDATE() in the stored procedure to supply the date.
What do I need to do to change to get this to save the date as mm/dd/yyyy
Miranda
Hi,
I am facing a problem. I have custom data flow transformation.We have saved a package using component's earlier assembly version. Now when we install later version of the component the saved package fails to open. If I try creating new package it succeeds.
Error message :
Error 1 Validation error. Data Flow Task: DTS.Pipeline: The component metadata for "component "Oracle Destination" (153)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Package.dtsx 0 0
We tried overriding "perform upgrade" method but still I am facing the same issue.
Dharmbir
I ran the SSIS wizard in Management Studio and saved the file in MSDB. I want to look at the design of the package but even going to BI development studio, I can't seem to find where you can open and work with the packages which were created in Management Studio and saved in MSDB. Anyone find a way to look at them?
View 1 Replies View RelatedHi guys!
I'm having troubles trying to import an excel file saved as XML.
Tried XML Source, Excel Source, OLEDB Source with no success.
Could someone point me to the right direction?
Thanks in advance.
I created my first package using the import wizard and saved it to the server. And now I can't find it. In SQL Server Mgt Studio, I've browsed through every imaginable folder in the target database, in MSDB database, and in the global folders.
I read something that suggested there should be an Integration Services folder, but there isn't.
Once I locate the package, I understand that it's not editable. Can it be transferred to BI Studio for editing? TIA.
Sorry for such a simple question -
I ran the Import data wizard and chose to save the package to sql server. Now I would like to execute that package I saved again, but I can't find where to do it in the management studio. Help!
I am calling a procedure that will save a file to PDF. It runs successfully. When I go to look at the PDF, I get a message, "Acrobat reader could not open 'Doc.pdf' because it is either not a support file or because the file has been damaged."
This is how I'm calling the procedure:
SaveFile(Dts.Variables("varSSRS_URL").Value.ToString() + "?/TestReports/MyReport&rs:Command=Render&rs:Format=PDF", "C:" + "MyReport.pdf")
hi i have question
can sql server know when the row in table Saved
add new field call "date_row_save" date+time
inside the my table in the sql server
i need to know whan the row last Saved
evry row put date time
TNX
Hi all,
I am not sure this is the right place to post this, but I could find a better place.
I uploaded a document in the SQL Server (image datatype), but I was not able to save file Type since there is no field for that, and cannot change the database.
Now I download the saved file. Is there any way to extract file Type from the saved file (like from file header?) and open it with an appropriate program such as doc file with MS Word?
Thanks,
J