Change Data Capture in Integration Services Packages

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 meeting but "this meeting has already finished".

Thanks,

Rafal

Hi Rafal,

You can still view the LiveMeeting. If you've registered for Katmai on Connect, go here to access the archived LiveMeetings.

-Chris
|||

Hi Rafal,

Change Data Capture is working fine in Katmai, I have already tested it.

Go to the below mentioned site. It clearly demonstrates the way to achieve it.

http://www.kodyaz.com/articles/change-data-capture.aspx

If still u find any problem doing so, do tell me where exactly you failing, might help you out|||

Rafal,

I can send the sample i used in the live meeting presentation, if you haven;t already got one, We plan to provide samples publicly very shortly, but this should help you out in the short term.

ThanksGopal

|||

Hi Gopal, The SSIS sample will be of help to us. I would appreciate if you cand send the sample. Thanks.

Change Data Capture in Integration Services Packages

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 meeting but "this meeting has already finished".

Thanks,

Rafal

Hi Rafal,

You can view the archived LiveMeeting. If you've registered for Katmai on Connect, go here to select an archived LiveMeeting.

-Chris

Change Data Capture in Integration Services Packages

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 meeting but "this meeting has already finished".

Thanks,

Rafal

Hi Rafal,

You can still view the LiveMeeting. If you've registered for Katmai on Connect, go here to access the archived LiveMeetings.

-Chris
|||

Hi Rafal,

Change Data Capture is working fine in Katmai, I have already tested it.

Go to the below mentioned site. It clearly demonstrates the way to achieve it.

http://www.kodyaz.com/articles/change-data-capture.aspx

If still u find any problem doing so, do tell me where exactly you failing, might help you out|||

Rafal,

I can send the sample i used in the live meeting presentation, if you haven;t already got one, We plan to provide samples publicly very shortly, but this should help you out in the short term.

ThanksGopal

|||

Hi Gopal, The SSIS sample will be of help to us. I would appreciate if you cand send the sample. Thanks.

Change color in a chart

Does anyone know how to change a chart color in reporting services?
I need a different color from colors available in the palette.
Thanks in advance,
ELEN.type into the related property box the color rather than use the pallet
eg Beside BackgroudColor there might be a [] Transparent
just type in #12ff21
ELEN wrote:
> Does anyone know how to change a chart color in reporting services?
> I need a different color from colors available in the palette.
> Thanks in advance,
> ELEN.|||You also need to make sure you have SP2 installed

Chalenge returning the first available number in a sequence

Hi all,

Ive been trying to figure this out and has proven to be quite difficult for me. Lets say i do a select on all client numbers from a clients table i would want the first available number returned.

Given the client table below my query would return 4 because its the lowest number availeble.

Thanks.

client table

clnum

1

2

3

6

7

Writing a single sql query for this task is challenging. Though I suggest that you could write a stored procedure that loops through a cursor pointing to clnum and check which number isn't present in the column:

psuedo code

open a cusor on clnum

loop i =1 to max int

loop thru the cursor and check if i is present ; if not then return i

end of loop

close the cursor

For help on using loops and cursors,seehttp://www.databasejournal.com/features/mssql/article.php/3111031

Hope this helps.

QI.

|||

Create a temp table or table variable, insert your clientid's and query from it. Something like this:

Declare @.ttable( Idint identity, clientidint)insert into @.tselect 1unionallselect 2unionallselect 3unionallselect 6unionallselect 7select top 1 IDfrom @.tWhere Idnot in (Select clientidfrom @.t)order by id

|||

This would not work if we already had 4 and 5 in the column as well. For example:

Declare @.ttable( Idintidentity, clientidint)

insertinto @.t

select 1unionall

select 2unionall

select 3unionall

select 4unionall

select 5unionall

select 6unionall

select 7

selecttop 1 ID

from @.tWhere Idnotin(Select clientidfrom @.t)

orderby id

The above code wouldn't return anything. Even though it should return 8, which is the lowest available number. Also, you want to be able to select from a column which may have an unknown number of rows so I don't think you can keep on doing unions like this.

QI.

|||

(1) If the ID returned is NULL, you can always query back with MAX(Clientid) and increment by 1. If you write a function to do this, it should be very simple.

(2) There is no need to manually write the INSERTs. That was just for a sample.

INSERT INTO @.T

SELECT Clientid

FROM Clients

would insert all the clients into the table.

Categories and Sub Categories

Hello,
I am working on a web site that makes documents available to students.
I am using tags to classify each document content.
So I have the following tables:
Documents, Tags, DocumentsTags
I also need to categorize the documents:
Subject
|-- Level
|-- Year
For example:
Document_1 - Math > University Level > Second Year
How can I create a table to create such classification?
Thank You,
MiguelHere is one way.
Have a table called Subjects, and add SubjectID to the Documents table with
a foreign key to Subjects (so that you only store "Math" once and it is easy
to update).
Add a column called Level to the Documents table.
Add a column called Year to the Documents table.
"shapper" <mdmoura@.gmail.com> wrote in message
news:24124f92-40c9-411e-8221-17119c78c7da@.j22g2000hsf.googlegroups.com...
> Hello,
> I am working on a web site that makes documents available to students.
> I am using tags to classify each document content.
> So I have the following tables:
> Documents, Tags, DocumentsTags
> I also need to categorize the documents:
> Subject
> |-- Level
> |-- Year
> For example:
> Document_1 - Math > University Level > Second Year
> How can I create a table to create such classification?
> Thank You,
> Miguel|||On Apr 24, 1:31 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Here is one way.
> Have a table called Subjects, and add SubjectID to the Documents table with
> a foreign key to Subjects (so that you only store "Math" once and it is easy
> to update).
> Add a column called Level to the Documents table.
> Add a column called Year to the Documents table.
> "shapper" <mdmo...@.gmail.com> wrote in message
> news:24124f92-40c9-411e-8221-17119c78c7da@.j22g2000hsf.googlegroups.com...
> > Hello,
> > I am working on a web site that makes documents available to students.
> > I am using tags to classify each document content.
> > So I have the following tables:
> > Documents, Tags, DocumentsTags
> > I also need to categorize the documents:
> > Subject
> > |-- Level
> > |-- Year
> > For example:
> > Document_1 - Math > University Level > Second Year
> > How can I create a table to create such classification?
> > Thank You,
> > Miguel
In the future I might need other categories. I was thinking in
something more flexible then that. Something like:
http://www.sqllessons.com/categories.html
I have two other tables:
Documents > DocumentID, Title, Description
DocumentsCategories > DocumentID, CategoryID
Then I was using Adjacency Model to create the table Categories.
This way I could have a Document associated to one or more categories
and at the same time I could have various levels of categories.
I am using LINQ to SQL so I would like to find a way to make this work
also with LINQ.
I am not sure if this is the best way but after Goggling this is the
closer I could find to solve my problem.
Thanks,
Miguel