|
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, 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.
|
|
|
Written by Stanislav Duben
|
|
Wednesday, 29 August 2007 |
In MSSQL 2005 is new T-SQL command OUTPUT, that was used only as output parameters in previous MSSQL version. Now you can use it in T-SQL commands to make data changes and see results by one command without using Triggers.
|
|
|
<< Start < Prev 1 2 Next > End >>
|
| Results 1 - 6 of 9 |
MSSQL 
