Showing posts with label object. Show all posts
Showing posts with label object. Show all posts
Sunday, March 25, 2012
Can you save XML to a Database?
The XML generated by notifications object needs to be saved. Where do I save it - in the database. That will still be stored in a table - with drawbacks!Not sure what the question is. You can save XML to a database or to a file.|||Sorry, I meant to say what does Integration services do when I deploy the project? Does it use XML to write to the database or the file system?|||You can store the packages in either the file system or the SQL Server MSDB database, your choice.|||How do I define the choice for later only database format? Is that something I have to specify as properties from Analysis services?|||I'm sorry, but I'm not sure what this has to do with Analysis Services. I'm talking about SSIS packages (files with a .dtsx extension). These can be deployed to either the database or the file system - you can't enforce that they are only deployed to one or the other when you are building the package. That's really an issue for your organization's policies and procedures.sql
Can you save XML to a Database?
The XML generated by notifications object needs to be saved. Where do I save it - in the database. That will still be stored in a table - with drawbacks!Not sure what the question is. You can save XML to a database or to a file.|||Sorry, I meant to say what does Integration services do when I deploy the project? Does it use XML to write to the database or the file system?|||You can store the packages in either the file system or the SQL Server MSDB database, your choice.|||How do I define the choice for later only database format? Is that something I have to specify as properties from Analysis services?|||I'm sorry, but I'm not sure what this has to do with Analysis Services. I'm talking about SSIS packages (files with a .dtsx extension). These can be deployed to either the database or the file system - you can't enforce that they are only deployed to one or the other when you are building the package. That's really an issue for your organization's policies and procedures.
Tuesday, March 6, 2012
.Net and SSIS
Hi,
Is there way I could pass on an object to an IS package from a .Net component? Basically I need to validate a file using c# and pass the valid records to an IS packet to be uploaded to the database. Is this possible without me writing the valid records to a file and using that as input for the IS packet?
Is there way I could pass on an object to an IS package from a .Net component? Basically I need to validate a file using c# and pass the valid records to an IS packet to be uploaded to the database. Is this possible without me writing the valid records to a file and using that as input for the IS packet?
I tried doing the validation on the IS side as well but seems extremly slow so going to try to get a c# program to do that for me.
Appreciate your help....If you want to reuse this code - write a custom data source component for data flow. If this is to be used once only - use a script component to create the source.|||Siv1 - if you're looking to programatically manipulate a SSIS package from c# code, check out the Microsoft.SqlServer.Dts.Runtime namespace. You'll need to import a reference to Microsoft.SQLServer.ManagedDTS.dll. You can load packages into .Net objects and manipulate from there (even run the package).|||
If you want to use the output of an existing .NET assembly within a package, then perhaps you'll prefer to approach things from the other end than Jeff suggested, and invoke your existing assembly from within a Script task or Script component (with the inconveniences around reusability that Michael mentioned).
However you can also do things the other way around, and run your package from a .NET application, and if the package terminates in a DataReader destination, load that DataReader output into your client app, as described in BOL.
-Doug
|||Thanks guys for giving me an idea on where to start...Sunday, February 19, 2012
...is null or not an object error
I am working in html/asp within VisInterDev 6.0. Everything was working fine until I moved a text box from one page to another. I took it from within a form on one page to a form on another (and made the necessary changes in the two pages).
Here is the code that is generating the error:
<body onload="java script:eventreg3.dist.focus();">
However I am using syntactically indentical code on other pages that work fine so I know the problem is not with that line.
It appears that it is not able to find the "dist" text box, but I have been over and over the html and can't find an issue. If I take that line out (keeping the <body> of course) it doesn't generate an error but my submit button doesn't work.
I have also noted that VisInterDev appears to eliminate, or not put in, double quotes around tag attributes. For instance, size="2" appears as size=2. I thought the double quotes were a requirement?
ANy help here? Thanks a ton!!!could it be the space between java and script?
rudy|||but that wasn't it. That space didn't actually exist in the code itself. Sorry for wasting your time. I have no idea what the deal is.
Here is the code that is generating the error:
<body onload="java script:eventreg3.dist.focus();">
However I am using syntactically indentical code on other pages that work fine so I know the problem is not with that line.
It appears that it is not able to find the "dist" text box, but I have been over and over the html and can't find an issue. If I take that line out (keeping the <body> of course) it doesn't generate an error but my submit button doesn't work.
I have also noted that VisInterDev appears to eliminate, or not put in, double quotes around tag attributes. For instance, size="2" appears as size=2. I thought the double quotes were a requirement?
ANy help here? Thanks a ton!!!could it be the space between java and script?
rudy|||but that wasn't it. That space didn't actually exist in the code itself. Sorry for wasting your time. I have no idea what the deal is.
Subscribe to:
Posts (Atom)