|
Written by Stanislav Duben
|
|
Friday, 15 January 2010 |
|
 I get strange error during redeveloping one SSIS. When I tried run some SQL task, finally such an easy one with "SELECT 1", I always received same error.
[Execute SQL Task] Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
|
|
|
Written by Stanislav Duben
|
|
Wednesday, 13 January 2010 |
|
Common situation, you need to make same changes in database, and you have column name. But you aren't sure in which tables this column is, where to look etc. Here is the simple solution.
|
|
|
Written by Stanislav Duben
|
|
Thursday, 07 January 2010 |
|
 Today I get interesting question. How to merge in MySQL two tables, where could be same primary key and different values. Result should be as select from one table with key column and 2 columns with both values from two tables, each in separate column.
|
|
|
Written by Stanislav Duben
|
|
Thursday, 15 October 2009 |
When you try drop column in MSSQL 2005 with some default value by ALTER TABLE xxx DROP column_name you get error about existing constraint. Unfortunately there is nothing like CASCADE CONSTRAINT. You must DROP constraint first and then you can DROP column. I will show you the easiest way, how to do it.
|
|
|
Written by Stanislav Duben
|
|
Thursday, 23 April 2009 |
|
For some solutions in SSIS you may need to go over all
records from some SELECT and each record use in some subqueries. In this case
you want loop record per record in some task series. Best solution is to use
Looping through recordset. Because of SSIS is intuitive enough to create this
task, here is step by step overview. In this step by step tutorial, I am using
AdventureWorks database from Microsoft. This database was created for testing
purpose and is ideal for our example.
|
|
|
Written by Stanislav Duben
|
|
Thursday, 17 April 2008 |
In previous content I showed how to use the OUTPUT command for printing inserted or updated records in a T-SQL query. It's simple, it's powerfull and saves us lines of code. Usually we need use these values in some larger script and assigned them to variables or insert them into other tables. Let's see how to do it.
|
|
|
<< Start < Prev 1 2 Next > End >>
|
| Results 1 - 6 of 11 |
