replace the source table in a dimension using DSO - Need help
Mon, 22 Sep 2008 01:39:00 -0700
HI
I want to change the source table using the DSO scripting .
For example the particular dimension has the source table as TABLE1
using the DSO scripting i want to change the source table to TABLE2
Can you please any help me regarding this
Thanks in advance
santosh
...
|
SSIS Script Component Output Columns Integer only
Sat, 20 Sep 2008 08:57:00 -0700
Hi
I am in Microsoft Visual Studio 2005 - Business Intelligence Project - SSIS
package.
I have my Excel data sitting in a global variable as an object. It is there
in one row, with only the column headings as I require.
I can create the script component with the source option to convert the
columns into ...
|
Suggestions for Syncing Large Number of Tables
Sat, 20 Sep 2008 06:48:01 -0700
Hi experts:
What are some good approaches on developing a syncing process of over 400
tables from one Access database to a SQL Server database that runs at least
twice/day or on-demand? I'm currently developing different solutions in SSIS,
.NET app, etc, to find the best one. I'd love to hear your thoughts ...
|
run time error in vb
Sat, 20 Sep 2008 12:09:08 GMT
hi sir i m getting run time error 214721900(80040e14) while inserting some value in the database althoug i dont find anything wrong with the syntax but its not working yet
From http://www.developmentnow.com/g/103_2004_3_15_0_0/sql-server-dts.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.c ...
|
Re: Dynamic Data Source Connection
Fri, 19 Sep 2008 07:19:01 -0700
Hi Sudhakara,
I need to do the same with excel connection, but, I am new to SSIS, so could
you send me a sample?
TIA
Daniela
"Sudhakara.T.P." wrote:
> Hi Allan,
>
> Thank you very much for the reply.
>
> Well I got hold of the solution after doing some more research on that.
> Thank you very ...
|
SSIS 2005 - Excel Destination
Thu, 18 Sep 2008 12:56:01 -0700
Hi,
I am new to SSIS. I created a pockage that extracts data from SQL and
export to an Excel spreadsheet. This package will run every day. The problem
is that when I execute the package the new data is appended to the end of the
spreadsheet. I need SSIS to overwrite the spreadsheet everytime it runs.
Any id ...
|
SQL Server 2008 Developer Edition backward compatibility
Thu, 18 Sep 2008 04:39:00 -0700
Im using Visual Studio 2008 for developing Web, Windows applications,
Services etc. I have installed SQL Server 2005 Developer Edition too for
creating SSIS, SSAS projects for company SQL 2005 Server.
Is there possibility to install only SQL Server 2008 Developer edition and
to have Visual Studio 2008 Prof ...
|
|
|
Using SQLCLR function returning SqlDateTime in DataFlow
Thu, 18 Sep 2008 04:24:01 -0700
I made SQLCLR function that returns SqlDateTime form integer value. I
deployed it succesfully on the server but I dont know, how to use it in the
DataFlow.
When I use it in the SQLQuery window on the SQL Server, it works well
example: SELECT dbo.JulianToGregorian (98001, 1900)
returns: 1998-01-01 00:00:00.0 ...
|
Debuging Custom DataFlow Component with own UI Editor (second post
Thu, 18 Sep 2008 04:01:01 -0700
Im developing custom DataFlow Component with my own UI Editor.
When I want to debug this component, I have to:
1. Uninstall old assembly from GAC
2. Change version in AssemblyVersion attribute
3. Change version in DtsPipelineComponent.UITypeName attribute
4. Recompile component
5. Install recompiled compone ...
|
SSIS Source connection change in runtime from Oracle to SQL
"VS_NEEDSNEWMETADATA"
Wed, 17 Sep 2008 23:02:14 -0700 (PDT)
i got a SSIS package that changes it source connection on runtime from
one oracle database to another oracle database, extracting the same
query from both databases.
this is done by setting a user variable to ConnectionString property
on OLEDB connection's expressions.
DelayValidation is set to True on connect ...
|
