After using row/page/index compression in SQL 2008 DB, I noticed that DB size is increased. Before compression the DB size was 69 GB. After row compression on all tables, size...

I need to pull data from Sybase into SQL using SSIS.

How can this be done? COuld anyone throw some light on this???? :w00t:

Any clue on where can i download the driver from???

Do i have to install this driver or does it come as a part of the BI?

:w00t:

Thanks :hehe:

I dont think using an SP would solve the issue as i need to send 2 attachments in the email

Oops... learnt a lesson. There was a trigger 🙁

Thanks man

I'm pretty sure that there are no such triggers

Thanks. But, I tired all these options and still the date entered into the table has a 3hr offset.

With your suggestion i accept that the date being entered would be...

I have not tried out this sort option. Should.

Anyways... i solved the issue by adding a script task which would add a RowNum (by partition) and then i pick the...

Thanks for the info

I'm new to SSIS.

Could you pls enlighten on how to use a temp table in SSIS?

Is it possible to fetch only the first matching record in the right table using the MERG JOIN component in the data flow?

Thanks for the post. But the source tables are not physical tables and the data read are from 2 different flat files. And so i wont be able to use...

Yup. That's the issue. Thanks for the reply