I have implemented delta detection while loading data warehouse from transaction systems using an identity column or date-time column in source transaction tables. When data needs to be extracted next time, the maximum date-time value extracted last time is used in the filter of extraction query to identify new or changed records. This w...
I am using an OLE DB command in SSIS for which the SQL command looks like this: UPDATE DBO.CLIENT SET TimeZoneID = ?, DaylightSavingTime = ?, ModifiedBy = ?, MicrosPropertyID = ?, IsOffline = ?, GlobalReporting_MaskPatronNumberType = ?, GlobalReporting_PatronNumberReadableCharacters = ?, GlobalReporting_M...
I'm trying to call an SSIS package through C# code. The package worked before I put a package password on, but now I'm trying to supply the password I'm getting an error that the password is wrong or not supplied. Package package = app.LoadPackage("mypackage.dtsx, null); package.PackagePassword = "mypass"; ...
I have an SSIS Package that utilizes a COM Interop (Interop.RFCOMAPILib.dll) around RightFax's COM API (rfcomapi.dll). The Interop assembly has been GAC'd so that we can use it within the SSIS package The package runs just fine on my local machine. But it also works just fine on the server if it is manually started (meaning all of the ...
Hi I have two excel source. Consider first has 5 (F1, F2, F3, F4, F5) columns and the second has two columns (F6, F7). I need to transfer this to a single table in the database which has all these seven columns. Which transformation, I should use to achieve this. Thanks ...
Unable to test sending email from .NET code in Windows Vista Business. I am writing code which I will migrate to an SSIS Package once it its proven. The code is to send an error message via email to a list of recipients. The code is below, however I am getting an exception when I execute the code. I created a simple class to do the ma...
I believe its possible to run SQL 2000 DTS packages on 2008 with a compatability layer. But is it possible to do the same with DTS packages created on SQL 7? Is there any MS KB or note that points out if this is even a possibility. ...
Guys, We are in the process of migrating from SQL 2000 to SQL 2005. We have hundreds of DTS pacakges, that the development team is reluctant to redevelop using SSIS. When migrating these packages to SSIS, I am faced with a problem - many of these packages read from Excel files. Given that my production Box is 64 bit, I am forced to u...
Hi I have SSISpackage which is developed in VS2008/SQL2008(Target Database),My source data is SQL2005. This package is execute with in the .Net framework of webservice. while executing am getting error with SOURCE Connection (with provider=SQLNCLI10 in connection string) getting error,the description as follows. Description: SSIS Erro...
I want to executing a select statement in SSIS, but this select statement takes a parameter from another component, and the column of this select statement must be used as inputs to other components. For example: select id from myTable where name = (column from a previous component). And the "id" content of the above select statement...
Everytime I run my data flow component, it gives me a validation error on a component whose name I cannot find in the editor! I think it happpened when I did ctrl-c on an existing component, and did ctrl-v. and it was successfully pasted, but somehow I can't see it, and therefore can't remove it!. My package is damaged as a result. Any i...
I have created a transformation component, and basically it accepts data from a source, and will do very transformations before it can save the information in a database. But, I want to map between the source columns and the database columns that are called up from my transformation component. I would like it to look like the mapping i...
Hi, I am trying to query out the attribute values from the xml file attached below. Specifically, I am trying to get the Name, SqlDbType etc. attribute values that are in the "Column" Element Node under"ColumnNullRatioProfile" Node. The xml output file comes as a part of the SQL Server 2008 SSIS DataProfiler Task. My goal is to use Pow...
Hi I have two diffrent web services(running on local machine) and pointing to one application pool(1.Can I do that?Is it any performance concern?).I have not much knowledge about how the applicationpool will works. the other .Net application is using two webservices,but frequently one webservice is not responding which internally ca...
I am attempting to use EzAPI to develop packages for Microsoft SQL Server Integration Services. In almost all cases, things work very well. However I am having trouble developing a package and data flow that reads from a SQL Server data source, passes the data to a Cache Tranform for caching and routes in into a Cache Connection manage...
In SQL 2008 the Backup Database Maintenance Plan Task has a collection property called "SelectedDatabases" I would like to pass a single value database name to this property. However the property requires a collection not a string. Is there anyway I can return a collection from the Expression Builder to achieve this. ...
I have a .csv file (semicolon separated) that I am trying to import into an SQL Server 2005 database using the Import and Export Wizard. Some of the entries in the .csv file are blank (i.e. two separators with no characters in between), and these should translate to NULL values in the destination table. The relevant fields are nullable....
I have a very simple component which trims all leading and trailing spaces from (read/write) strings in a pipeline. As far as I can see, I only have one binary of this dll on my development machine. I am transferring it to another development machine and registering it in the GAC, but when I open a package I copied to the second machin...
Hello, I'm trying to run a simple SSIS package (copies data from an outside folder into a SQL 2005 table). I want to run this package from an Asp.net 2.0 application. Any suggestions? I have searched many different blogs and websites, but all of these methods lead to failure (usually because of security issues) dtexec /FILE "name of...
Im trying to call the procedure with this form. EXEC dbo.sp_consulta param In parameters mapping i have this variable: "param". In the variable that is holding the parameter im assigning int16 as the type but for the parameter type there is no int16, so I'm using short or signed. The error I'm getting is this: error converting data t...