Read SP Source Code From VB
Jul 20, 2005Hi,
I'm developing an application to crypt SQL databases and i need to
read SP and Views source code from VB6, if you know how to do this
please answer me.
Greetings.
ADVERTISEMENT
How To Get Read Only Control Value Through SQl Data Source
Nov 7, 2006Hello,
I am using this sql data source control.
<asp:textbox runat="server" id="txtFromDate" ReadOnly="true"></></asp:textbox>
<asp:textbox runat="server" id="txtToDate" ReadOnly="true"></asp:textbox>
--------------------------------->
<asp:sqldatasource id="dsClickInfo" runat="server" connectionstring="<%$ ConnectionStrings:activeConnectionString %>"
selectcommand="SProc_GetTransaction" selectcommandtype="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter QueryStringField="Id" Name="MerchantID" Type="int32" />
<asp:ControlParameter ControlID="txtFromDate" Name="StartDate" PropertyName="Text"
Type="String" DefaultValue="0" />
<asp:ControlParameter ControlID="txtToDate" Name="EndDate" PropertyName="Text"
Type="String" DefaultValue="0" />
</SelectParameters>
</asp:sqldatasource>
I abouve code txtFromDate and txtToDate are marked as readonly so sqldatasource is not able to get value from these controls.
How is it possible?
Please help me..
No Records Read From XML Source Xml File.
Apr 12, 2007I have a simple data flow where I am trying to import data from an xml file into a SQL Server table. I have an xsd that seems to work because the XML Source can pick up all the elements in the xml file. The problem is that the process executes successfully without any rows being imported. The xml file has lots of data. But no messages or warnings are given to suggest why no rows are being written to the table.
View 21 Replies View Related0x80131500 Error While Trying To Read An XML Source
Jul 19, 2006Hi,
This is my first time trying to import data from an XML file. It seems wonderfully straightforward. I currently have my Data Flow set up correctly. However, when I try to run my package I get a series of errors. One error is a 0x80131500 which is a very generic error. It say's it's haveing a hard time with a 'Url' field in the XML. The size of the field is set to 255 which should take care of any issues with Truncating. The only issue that I can see with that field is that it contains a query string which of course contains a special '&' XML character (&). When I set the Error Handling to Ignore that Error on that column, it imports just fine, however, NONE of the URL's get inserted. So there must be a problem with every URL in the XML. Here are the error messages I recieved from the Progress section:
[XML Source [1]] Error: The "component "XML Source" (1)" failed because error code 0x80131500 occurred, and the error row disposition on "output column "Url" (59)" specifies failure on error. An error occurred on the specified object of the specified component.
[XML Source [1]] Error: The component "XML Source" (1) was unable to process the XML data. Pipeline component has returned HRESULT error code 0xC0209029 from a method call.
----And then alot of DTS.Pipeline errors.
I have done alot of searching for this error in regards to SSIS, but the information is scarce. Any and all help would be greatly appreciated. Thank you for your time in this matter.
P.S. Just started using SSIS last week and I love it! The team did an excellent job!
How Do I Read An Extended Property Of A Database In Code?
May 8, 2006I have recently had the need to create a utility program to upgrade the schema of an existing database for users of my program at install time. I will be using SQL Management Studio to generate the change scripts the program will use, but I will need some kind of way to know what version of the database a user has installed.
After poking around in SQL Management Studio I found a place for "Extended Properties" on a database, and I thought this would be the perfect place to add a property called "SCHEMA_VERSION" to know what version of the database is installed.
I have no idea how to read and update this value in code though. Can someone provide a small example on how to read and update an extended property on a database? Any .NET language example is welcomed; C# is preferred. Thanks in advance!
How To Read File Information From Source Folder!
Mar 6, 2008I am new to SSIS and I am trying to do following thing using WMI Reader Task.
I have developed SSIS package which import data from flat files.
Now I have to add following functionality to SSIS package
Before SSIS package load data I would like to check If there are all files in source folder and check the files are with current date.
If both condition true then only load data.
After some research i found that WMI uses specialized query language known as WQL, which is similar to SQL, to obtain information on files and directories.
Also i found that Under WMI Reader Task editor properties you can write WQL query to receive file information from source folder.
Can Anyone suggest me What WQL query i have to write to retrive file information from Source folder?
Or
Any Other suggesion i should approach?
Please advise me!...Any help would really appriciated...
Read Source Data Without Waiting For Possible Locks
Mar 16, 2007hi!
I wonder if anyone can tell me how we can run select queries in an OLE DB data flow task and tell the target SQL 2000 server it should allow reads at all time. Currently when a lock is on the source table our SSIS package will sit and wait untill the lock on the source table is gone.
Thanks.
Marc
Transferring Data From Read-only Source To Destination.
Oct 17, 2006Hi,
I have read only permission in the source (OLTP) database. The source database is running in SQL Server 2000 and the size is more than 200 GB. I need to pull data from source and load target which is running in SQL server 2005.
Following are the objectives I want to achieve.
Data should be loaded on incremental basis.
Whatever changes take place (Update/Delete) in source, that should be replicated to already uploaded data.
Here I want to mention that, the source database does not have any identification key or timestamp column like Updated_Date by which I can filter the data which are recently inserted or updated into the source and upload the same. The source does not maintain any history data also. So I do not have any track of deleted record also.
I don€™t have any scope to change the schema in the source. In this scenario can anybody suggest me the best approach to achieve the above mentioned objectives?
Can I retrieve only the recent updated or inserted date form transaction log back up. Can log shipping solve the give the solution?
One more question. Say I have a table and I am exporting/importing all the data from/to my target table using SSIS or DTS. In this scenario does using query or using directly the table affects the performance?
Regards
Sudripta Rakshit
SSIS Excel Source Read Problem
Jun 23, 2006I have a problem with reading data from an Excel file in SSIS. I'm trying to read a column that mostly consists of decimal values, but there are couple places where column entry is 2 numbers separated by a slash (e.g. "100/6.0"). SSIS tries to be smart and identifies the column data type as decimal and when it reads the cell with the slash in it, it reads as NULL. I tried to make my excel source reader component to read that cell as a string, but it gives me an error. If anybody has come across something like this, I would highly appreciate some help
-Erlan
Reg: How To Read Record One By One From File Source In SSIS
Apr 18, 2008Hello,
Is there any way to implement sequence data read.
Note:
source is .csv or flat file file
i want process the records one by one.
please give me the solution ASAP.
Thanks
Thiru
No Response To Code And Query Analyser Cannot Read Statement
Feb 20, 2004hi
have a problem ...
I tried to test my statement in QA as it returns no dataset ,it gives me empty columns in return,I though it will return all the columns and some records of (lmeyer) as the current user ,who logged in on windows auth,but it return only the columns,is that means my query analyser cannot read the login1 ,column which has the username as (lmeyer)
select * from tstudents where (login1='@param1')
if not what could me wrong in my code ,because I get no response to the sql server
Public Function login(ByVal login1 as string) as dataset
Dim myconnection as new sqlconnection("server=G103-TT03;database=CampusLANDB;Trusted_Connection=yes")
dim mycommand as new sqlcommand ("Select * from tStudents Where login1 = @param1",myconnection)
mycommand.parameters.add(new SQLClient.SqlParameter("@param1",login1))
dim DS as new dataset()
try
myconnection.open
dim adpt as new sqldataadapter
adpt.selectcommand = mycommand
adpt.fill(DS,"tStudents")
catch ex as exception
throw new exception(ex.message)
return nothing
finally
myconnection.close
end try
try
mydatagrid.datasource=DS.Tables("tStudents")
mydatagrid.databind()
catch ex as exception
errorlabel.text=ex.message
end try
return DS
End Function
thankx in advance
pamela mkosana
Amo And Creating Data Source And Data Source View Code
Feb 2, 2008,
Hi
In this code how can I create a new data source and new data source view and model and structure that it run dynamic.
In this code I have a lot of errors, that they are about server and database don€™t have in current code,
In this code, first I should definition server or no?
Database dbNew = new Database (databaseName,
Utils.GetSyntacticallyValidID(databaseName, typeof(Database)));
srv.Databases.Add(dbNew);
dbNew.Update(true);
***********************************************************
How can I create data source and data source view and model and structure?
Please say code of that, and guide me.
databasename and srv is unknown.
Do I add other reference with analysis services?
Please explain about these codes:
************************************************************************
1)
RelationalDataSource dsNew = new RelationalDataSource(
datasourceName,
Utils.GetSyntacticallyValidID(
datasourceName,
typeof(RelationalDataSource)));
db.DataSources.Add(dsNew);
dsNew.ConnectionString = connectionString;
dsNew.Update();
2)
RelationalDataSourceView rdsv;
rdsv = db.DataSourceViews.Add(
datasourceviewName,
Utils.GetSyntacticallyValidID(
datasourceviewName,
typeof(RelationalDataSourceView)));
rdsv.DataSourceID = ds.ID
***************************************************************
3)
OleDbConnection cn = new OleDbConnection(ds.ConnectionString);
OleDbCommand cmd = new OleDbCommand(
"SELECT * FROM [" + tableName + "] WHERE 0=1", cn);
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
DataSet dss = new DataSet();
ad.FillSchema(dss, SchemaType.Source);
*************************************************************
4)
// Make sure we have the name we thought
dss.Tables[0].TableName = tableName;
// Clone here - the original DataTable already belongs to a DataSet
rdsv.Schema.Tables.Add(dss.Tables[tableName].Clone());
rdsv.Update();
5)
MiningStructure ms = db.MiningStructures.Add(miningstructureName, Utils.GetSyntacticallyValidID(miningstructureName,
typeof(MiningStructure)));
ms.Source = new DataSourceViewBinding(dsv.ID);
ms.CaseTableName = "Customer";
Add columns:
ScalarMiningStructureColumn smsc;
// From table "Customer" we will add a couple of columns
// CustomerID - key
smsc = new ScalarMiningStructureColumn("Customer ID",
Utils.GetSyntacticallyValidID("Customer ID", typeof(ScalarMiningStructureColumn)));
smsc.IsKey = true;
smsc.Content = "Key";
smsc.KeyColumns.Add("Customer", "customer_id", OleDbType.Integer);
ms.Columns.Add(smsc);
*******************************************
6)
MiningModel mm = ms.MiningModels.Add(miningmodelName,
Utils.GetSyntacticallyValidID(miningmodelName,
typeof(MiningModel)));
mm.Algorithm = "Microsoft_Decision_Trees";
mm.Parameters.Add("COMPLEXITY_PENALTY", 0.3);
MiningModelColumn mc = new MiningModelColumn("Customer ID",
Utils.GetSyntacticallyValidID("CustomerID",
typeof(MiningModelColumn)));
mc.SourceColumnID = ms.Columns["Customer ID"].ID;
mc.Usage = "Key";
mm.Columns.Add(mc);
mm.Update();
Please exactly say, whatever I want
Thanks a lot for your answer
Please don€™t move this question because I don€™t know where I should write this.
SSIS Data Flow Source Component To 'read' A PDF File
Feb 13, 2008At our business we are getting a lot of PDF documents that are being hand keyed into a database. Has anyone heard ior know of a SSIS Data Flow Source component that I coud use to read thos documents into a data stream (?) and process?
View 5 Replies View RelatedSource Code Required
Feb 18, 2004A Source code required for create SQL Server Database,Tables,Procedures programatically
View 1 Replies View RelatedHow To Get Source Code Of A View ?
Apr 11, 2008
Hi,
I am trying to get source code of a view (SELECT part) into an TSQL variable, but I have no idea, where to find this source code and how to proceede the assignment ? Any idea ? thanks
Uninstall Error : The Setup Failed To Read IISmimemaptable The Server Code Is 2147024893
Feb 23, 2007Hi, I get the following error message error : "the setup failed to read IISmimemaptable the server code is 2147024893" and I cannot uninstall SQL Server 2005. Any idea this is happening. thanks!
chi
Script Component As Source: The Collection Of Variables Locked For Read Access Is Not Available At This Point.
Jan 17, 2008Hello, I am trying to configure a Script Component as a data source. Although this should be a simple exercise, I am running into a problem.
My control flow contains a Foreach Loop with a file iterator. The Directory Expression of the Foreach Loop Editor is supplied by an expression mapped to a package level variable called inputdirectory. The FileNameRetrieval Expression is mapped to a package scoped variable called filename.
My data flow is encapsulated by the Foreach Loop, and contains a Script Component as Source for the Data Flow Source, and a Flat File for the Data Flow Destination. The contents of the Script Designer are as follows:
Code Block
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.IO
Public Class ScriptMain
Inherits UserComponent
Dim thisFileDate As Date
Dim thisFileName As String
Dim thisFilePath As String
Public Overrides Sub CreateNewOutputRows()
thisFileName = ReadOnlyVariables("filename").Value.ToString()
thisFilePath = ReadOnlyVariables("inputdirectory").Value.ToString()
thisFileDate = File.GetCreationTime(thisFilePath & "" & thisFileName)
FileSpecBuffer.AddRow()
FileSpecBuffer.FileName = thisFileName
FileSpecBuffer.FullPath = thisFilePath & "" & thisFileName
FileSpecBuffer.CreateDate = thisFileDate
End Sub
End Class
When I debug the package, I get the following error:
The collection of variables locked for read access is not available at this point.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.get_ReadOnlyVariables()
at ScriptComponent_67311120e6eb4162a3ea1f70847f04de.ScriptMain.CreateNewOutputRows()
at ScriptComponent_67311120e6eb4162a3ea1f70847f04de.UserComponent.PrimeOutput(Int32 Outputs, Int32[] OutputIDs, PipelineBuffer[] Buffers)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
My googlefu fails me at reconciling this. I have read various posts about changing the line ReadOnlyVariables("filename").Value to ReadWriteVariables("filename").Value, and handling the buffer assignment in PostExecute. The problem is that all examples shown are either for Script Component as Destination or Script Component as Transformation. I have tried playing with the Custom Properties in the Script Commponent set the ReadOnlyVariables and ReadWriteVariables, using a PreExecute method, a PostExecute method, all with different errors returning. I'm at a loss here. Could anybody provide me with a simple working example so that I can correctly populate my output buffer in the context of Script Component as Source?
I fully understand that I could just run a Script Task Using System.IO.Directory, and System.IO.File, but I really want to make this package work in the manner I've described. Any help would be appreciated.
Thanks,
John T
Integration Services :: Source Script Component To Read Data From Sharepoint List?
Apr 29, 2015All examples I found refer to classes under Microsoft.SharePoint namespace. However, I have the SharePoint CSOM that only gives me the Microsoft.Sharepoint.Client namespace.
I need to read the selected values of a multichoice field, but not sure how to do it with classes in the namespace above.
everthing works, exept the TSQL_x0020_Reference_x0020_Numbe field.
my code looks like this:
Webweb = cont.Web;
cont.Load(web);
cont.ExecuteQuery();
Listsstest = web.Lists.GetByTitle("T-SQL
Code Review Tracking");
//CamlQuery query = CamlQuery.CreateAllItemsQuery();
[code]....
SP Source Code Control In MSSQL 7.0...
Sep 7, 2000Hi,
We use a lot of stored procedures within our project and I am looking for a source code/versioning control software that can be used with SQL Server 7.0 to track any changes to these stored procedures. Does anyone have any suggestions?
Thanks in advance,
Darrin Wilkinson
Source Control / Code Deployment
Jan 3, 2008Look for recommendations for the best product out there to facilitate both source control and code deployment. Typical features I would be looking for are bullet below:
Control object versions
Tracking
History
Automated feature
Capture database changes
Roll-back feature (should such a thing exist)
Thanks
How Do You Show Your Source Code Using A System St
Feb 28, 2008In SQL Server 2005, how do you list your source code of a specific procedure using a system stored procedure?
Thank you for the help!
Programmatically Get ScriptTask Source Code
Sep 8, 2006Hi am trying without luck to load a package which contains a ScriptTask and read the source code of that task.
I can load the package and get the ScriptTask no problem.
However i am not sure how to get the source code.
I know i have to use the ScriptTaskCodeProvider and i assume the GetSourceCode() method.
This is what i have so far
ScriptTask scriptTask = taskHost.InnerObject as ScriptTask;
ScriptTaskCodeProvider codeProvider = new ScriptTaskCodeProvider();
codeProvider.LoadFromTask(scriptTask);
string sourceCode = codeProvider.GetSourceCode(scriptTask.VsaProjectName);
Any assistance greatly appreciated.
Cheers
Richard.
SSIS Source Code Library For Others To Use
May 12, 2006In SSIS can one create €œuser defined functions€? €œsubroutines€? and put them in the SSIS designer for other developers to use?
TIA,
Bill
Need VB.NET Custom Components Source Code Example
May 21, 2006I need VB.NET source code showing how to create a Custom Component. in SSIS (All the ones I've seen are written in C#.)
TIA,
barkingdog
Printing Source Code From A Local Package
Sep 20, 2000Is there a way to print the source code from the local package. I know you can go in the source and cut and paste it into a word document. I was wondering if there was a way to do it when you are in designing the package so that it would print all the source codes of SQL statments/queries.
View 1 Replies View RelatedHow To Hide The Source Code Of Store Procedure?
Feb 22, 1999The problem is as subject line shown.
Please Help.
Thanks for all.
J.H.
Code For Creating A Table In SQL From External Source
Nov 18, 2005I'm looking to create a table in SQL using data from the as/400. I need some code that extracts it from as/400 using odbc and I need it to loop and create that table every minute.
The file its retrieving is a live file but not very large.. I need to basically poll the data. Does anyone have code for something like this..
thanks
Source Code For Windows Forms Viewers?
Jul 11, 2006Any plans to make the source code of the Windows Forms data mining viewer controls publicly available?
View 1 Replies View RelatedReporting Services - Recovering Source Code
Mar 7, 2008Hi all,
I am in a situation where some reports were developed by a colleague who left the company.
The reports were published on the server but since the code behind the reports was deleted inadvertently.
We don't have documentation about them.
My questions are:
is there a way to recover the source code?
is there a way to produce a report showing a list of the reports and the underlying data straucture/stored procedure, even in cases where the RDL is missing (i.e. from the published report)?
Many thanks in advance
Massimo
Code Page Problem With IBM ISeries Source
Nov 19, 2007Hello,
I'm not up to speed on the IBM database and provider technologies, and I have an issue that I'm not clear on. I am using the .Net ODBC Data Provider in a connection mananger. The DSN uses the iSeries Access ODBC Driver. I have iSeries Access for Windows version 5 release 4 installed on laptop where I have built the package.
I have a sql command configured in a DataReader source that uses the connection manager. Between the source and sql server table destination, I have a Derived Column transform that converts the columns from Unicode to non unicode data.
When I run the package, I get an error that states that the package failed because a particular column, 'ADDR1' is set to fail if truncation occurs. I set up error output to a text file so that I could look at the failing row(s). The text file had to be set up using UTF-8 before it would accept data. The ADDR1 column at the destination will accept 30 characters. The data in the ADDR1 column of the failing row is 19 characters long, but I think there is a carriage return character present. I have tried TRIM in the exression for the column, but no luck. I have tried code pages 65001, and 37 in the Derived Column transform, but that has not worked. I remembered to set up DefaultCodePage and AlwaysUseDefaultCodePage for the OLE DB destination for each code page change.
Am I not using the correct code page, or do I need to do something else to clean up the data?
Thank you for your help!
cdun2
Configuring The Code Page Of A OLEDB Source.
Jun 25, 2007hi,
i have a number of interfaces in which i have used oledb source.
the problem i am facing is oledb source components code page is not configurable now if i want to deploy the interface in a different environment which has a database with a different collation it gives a error that oledb source needs new metadata.
has anybody faced this problem earlier.please give me a solution to this problem ..
thanks in advance.
srikanth
Source Code Control And SQL Server Express??
Apr 18, 2006Hi,
I was wondering if anybody could advise on source code control for SQL Server express, for the table schema and stored procedures?
I currently use Sourcesafe V6 to work with visual studio 6 and 2003 (although it isn't integrated in 2003), and wondered if that can be used?
Any suggestions would be greatly appreciated, as I see this as a disaster waiting to happen!
Thanks in advance.
Mark
Excel Source (351) Returned Error Code 0x80040E21
Oct 19, 2007[DTS.Pipeline] Error: The PrimeOutput method on component "Excel Source" (351) returned error code 0x80040E21.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Here is my request: Print out the row number and the contents of the offending field when an error like this occurs.
Wish list item:Have One Switch that tells SSIS to keep going and skip bad row.
Now I have to tell it twice for every field and it still stops!
Enough already. Why let one bad record stop 65,000?
IanO