View Complete Post
We have a moderately complex SSIS package that uses a script task to dynamically create a Transfer SQL Server Object task, which then moves data and schema of a varying definition
from source to destination. The SSIS package was written in BIDS 2005.
The source system is still SQL 2005 (with latest updates) and the destination system is now 2008r2 (with latest updates).
When the package run, we get the following error when we try to execute the dynamically created transfer task: Description: Execution failed with the following error: "Version90 database compatibility level is not supported.".
sp_dbcmptlevel for the source and destination databases returns "The current compatibility level is 90.".
Master on the target system is predictably at level 100.
This leads to several questions:
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
I have a form in which I display data from a database table, change the data and then update the database table. The form consists of textboxes, so all data displayed in the form is string. However - one data is int in the database table (the rest is varchar), so I need to convert it from string to int when I update the database table. How do I do it?
protected void SaveProd_Click(object sender, EventArgs e)
string BildID = TextBoxProdPictID.Text;
string namn = TextBoxProdName.Text;
string kategori = TextBoxProdCategory.Text;
string stl = TextBoxProdSize.Text;
string pris = TextBoxProdPrice.Text;
string iLager = TextBoxProdNumberOf.Text; //this is int in the database table
SqlConnection conn = new SqlConnection(config);
string sql = "UPDATE Produkter SET kategori ='" + kategori + "', namn ='" + namn + "', stl ='" + stl + "', pris ='" + pris + "', iLager ='" + iLager + "' WHERE ID ='" + ID + "'";
SqlCommand comm = new SqlCommand(sql, conn);//Conversion failed when converting the varchar value '__Page' to data type int.
SqlDataReader dr = comm.ExecuteReader();
I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008. I tried to follow instructions from articles on incremental data load in SSIS using MD5 hashes but I failed to make connection in Lookup transformation
editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is bigint. i tried to add data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup
component it failed.
Any input greatly appriciated.
Hi, I am trying to insert log information into netezza db from ssis package. i have used "SSIS log provider for SQL Server" log provider. but i have got the below error message.
Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Netezza Performance Server" Hresult: 0x80004005 Description: "ERROR: 'sp_ssis_addlogentry ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?'
error ^ found "SP_SSIS_ADDLOGENTRY" (at char 1) expecting a keyword".
This provider can be used only to insert log information into SQL server or to any other db as well?.
if not, is there any provider to be used for netezza? or is there any work around to insert logging information into netezza db table.
Any help would be greatly appreciated!
I am just wondering if this is a feasible option within SSIS.
I have a source database on one server, a destination database on another server
The source database has a stored procedure which returns lets say 500 records. 300 are inserts the rest updates. (Based on some column)
So in SSIS I call this SP, following this im able to loop through the records returned figure out wether its Insert or Update and then move the data to destination table.
I've created my own custom settings provider to save user settings (formerly in the user.config) to a database. To point the particular settings that are to be saved to the database I specified
for each property to point to the BlobSettingsProvider instead of allowing them to default to the LocalFileSettingsProvider.
Now I need to convert existing user.configs to save to the database on the fly - a one time conversion. Because I've now specified the properties to use the BlobSettings provider they can no longer access the local user.config.
Does anyone have any thoughts on how best to accomplish this conversion (i.e. read the local user.config and populate the BlobSettingsProvider). The app can be run as a ClickOnce installed app or as a simple .net app - finding the correct local user.config looks to be a problem.
Am using searcharoo.NET for ma application. Now i need to store the XML contents in ma database. How can i convert ma XML contents to Mysql Database? Please help me.
Any help will be appreciated.
I have been trying to create an Issues Web Database on one of our MOSS 2010 servers, but I keep getting the error "The formula contains a syntax error or is not supported" when I try to. I have tried this on one of our other 2010 environments and it works
fine but for some reason it happens just one this one.
In the error logs I found this:
Error updating field: List: Issues, SchemaXml: <Field DisplayName="OpenedDate" Type="DateTime" Required="TRUE" Format="DateOnly" xmlns="http://schemas.microsoft.com/sharepoint/soap/" Name="OpenedDate"><DefaultFormula>=TODAY()</DefaultFormula><DefaultFormulaValue></DefaultFormulaValue><Validation
Message="Value must be greater than 1/1/1900.">=OpenedDate>=DATETIME(1900,1,1,0,0,0)</Validation></Field>. Exception: Microsoft.SharePoint.SPException: The formula contains a syntax error or is not supported.
Does anyone have an idea as to what the cause might be?