Predictive Analytics event Oct 24-25 (DC) and Nov 6-7 (SF)
Tue, 23 Sep 2008 00:28:25 -0700 (PDT)
Hi, I wanted to make sure you were all aware of these upcoming events.
There is a seminar in Predictive Analytics on Oct. 24-25 in DC, and in
San Francisco Nov 6-7. This is intensive training for managers,
marketers, and IT people who need to make sense of customer data to
predict buying behavior, profit, etc. ...
|
Same connection manager for multiple control flow tasks
Mon, 22 Sep 2008 14:58:00 -0700
New to SSIS so bear with me....
I have migrated a 2000 DTS package to a 2005 SSIS package. The migration
wizard converted all DTS tasks(20 tasks) to an "EXECUTE DTS 2000 PACKAGE
TASK" control flow item(20 control flow tasks). The task is a simple extract
from an Excel worsheet and load into a SQL 2005 dat ...
|
Create Assembly for Referencing in ScriptComponent
Mon, 22 Sep 2008 03:14:01 -0700
What specific things have to do, that I will be able referencing my own
assembly in the script editor in DataFlow ScriptComponent.
I Strongly signed my asembly, install that into the GAC, but I cannot see it
in the list of asseblies in the ScriptComponent references. There is nio
possibility to browse for t ...
|
replace the source table of dimension using the DSO scripting
Mon, 22 Sep 2008 01:39:01 -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
...
|
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 ...
|
