Recent update: 2008-3-21
I'm getting an error with the script task - I suspect some sort of installation problem but any pointers would be gratefully received. I've created a package with just a script task. I've then edited the task and inserted one line: Code Snippet Public Sub Main() ' ' Add your code ...
SSIS 2005 Execute Package task doesn’t have properties to support dynamic configurations. Here are a couple of scenarios: 1) Package could be executed on its own. In such scenario it is easy to make the package use an external configuration file. 2) The same package could be executed as a ...
2031 byte By
Kruz at 2008-3-5
Hi Guys, When I try to import data into Sql 2008 July CTP, I get the following error: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection ...
SSIS 2005 Execute Package task doesn’t have properties to support dynamic configurations. Here are a couple of scenarios: 1) Package could be executed on its own. In such scenario it is easy to make the package use an external configuration file. 2) The same package could be executed as a ...
Dear All can i upgrade from DTS on sql Server 2000 to SSIS on SQL Server 2008 and what is about compatability? thanks ahmed mosa
2031 byte By
Kruz at 2008-2-28
Hi Guys, When I try to import data into Sql 2008 July CTP, I get the following error: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection ...
Dear All can i upgrade from DTS on sql Server 2000 to SSIS on SQL Server 2008 and what is about compatability? thanks ahmed mosa
2259 byte By
PK2000 at 2008-2-26
Hi, I have a SSIS packages which I've developed on SQL 2005 (SP2) which contains a number of ActiveX script task objects and it runs successfully on SQL Server 2005. When I tested the same SSIS package on SQL Server 2008 (June CTP) all the ActiveX scipt tasks fails without any great details ...
Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE). All these weird messages came out after I uninstalled ...
Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE). All these weird messages came out after I uninstalled ...
Hi All, Are there any new enhancements in SSIS with regards to data cleansing? Im speaking of direct data cleaning beyond fuzzy grouping such as householding or other specific scenarios? Regards, Joseph ...
Hi, Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages? I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live ...
259 byte By
ccote at 2008-2-22
H, I downloaded and installed the June CTP of Katmai. It looks the same as SSIS 2005. I would have expect to see improvements made to lookups (connectivity, cache) but did not find it. Are these improvements into June CTP? Thanks, Ccote
After I aborted my installation of the tools that come with Katmai, I could not create Integration Services project nor add package to an existing project. I get the following errorConstructor on type 'Microsoft.DataTransformationServices.Wizards.EtlProjectWizardInitializer' not found.I've ...
After I aborted my installation of the tools that come with Katmai, I could not create Integration Services project nor add package to an existing project. I get the following errorConstructor on type 'Microsoft.DataTransformationServices.Wizards.EtlProjectWizardInitializer' not found.I've ...
Final Check.
Hi, does SSIS 2008 will finally offer a "between lookup"? the current lookup support only the equal (=) operator, but when we play with Type 2 SCD dimensions, its important to also test the dates using a between. or better, the operator used in the comparison should be an option ...
I read on the SQL Server 2008 Overview paper that there is a new "SSIS persistent lookup" feature. Performing lookups is a common operation, especially in data warehousing, where fact records must use lookups to transform business keys to their corresponding surrogates. SQL Server ...
142 byte By
jaegd at 2008-2-16
Will Katmai support breakpoints in script components? And along the same lines, will the immediate window support expression evaluation?
977 byte By
jaegd at 2008-2-15
Will the Microsoft.SqlServer.VSTAScriptTaskPrx assembly effectively replace MicrosoftSqlServer.ManagedDTS assembly for script tasks?There are a number of script tasks which use ManagedDTS (e.g. new Application() + associated function calls) that no longer work with Katmai. For example, I've ...
1256 byte By
jaegd at 2008-2-15
Installing Katmai took 4 attempts, all of them on Virtual PC 2007. In my experience, CTPs should be installed on virtual machines, because VMs are relatively easy to replace, particularly with the undo disk functionality.1. First attempt installing Katmai June CTP. Vista Business x86 guest / ...
547 byte By
jwelch at 2008-2-15
In the June CTP, it looks as if the way to use the MERGE statement would be to have your data flow write all rows to be inserted or updated to a "temporary" table, then use an EXECUTE SQL task to run the MERGE statement to upsert the target table. Is that correct? If so, are there any ...
Hi,does SSIS 2008 will finally offer a "between lookup"?the current lookup support only the equal (=) operator, but when we play with Type 2 SCD dimensions, its important to also test the dates using a between.or better, the operator used in the comparison should be an option instead ...
In a newly created maintenance plan I add a Check Database Integrity Task. I open it, leaves the default selection of Local Server Connection, chooses specfic databases and then click ok. There's still a red bullet telling me that "There were errors during task validation." How can ...
In a newly created maintenance plan I add a Check Database Integrity Task. I open it, leaves the default selection of Local Server Connection, chooses specfic databases and then click ok. There's still a red bullet telling me that "There were errors during task validation." How can ...
1284 byte By
Ed77 at 2008-2-14
We are porting an existing package from SQL Server 2005 to Katami and are getting the following error:Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not ...
1284 byte By
Ed77 at 2008-2-13
We are porting an existing package from SQL Server 2005 to Katami and are getting the following error:Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not ...
1288 byte By
Ed77 at 2008-2-13
We are porting an existing package from SQL Server 2005 to Katami and are getting the following error: Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not ...
We've currently been working with SSIS by using the xml functionality within in sql2005 combined with delivering XML encoded in non iso-8859-1 encoded files, and there is very little component support for this kind of integration scenario. - We are basically forced to use script components for ...
We've currently been working with SSIS by using the xml functionality within in sql2005 combined with delivering XML encoded in non iso-8859-1 encoded files, and there is very little component support for this kind of integration scenario. - We are basically forced to use script components for ...
Hi All, Are there any data cleansing enhancement or features that is included in KATMAI? Something more in the line of householding, data catagorization and such? Regards, Joseph