Your answers are confusing. Perhaps if you provided some sample data and details of where you want it to go it would clarify things.

var05 (11/19/2012)

---

Hi All,

--

Say if there are 100 new data coming in today into the source,then I wanted to look up the destinationand load only the newly inserted data....Is SSIS look...

It would be useful background info to have some idea of what your source and destination are - is this a flat file to SQL Server import, or something different?

I...

1) Create UDF in T-SQL as usual.

2) Add an ExecuteSQL task which calls the function, eg

Can you please elaborate on the reasons...

martinez.math (11/16/2012)

---

Simple way to compute your age accurately.

A lot of query not exactly compute the age? yes! because sometime they only compute the datediff between DOB and datenow and divide...

Craigmeister (11/15/2012)

---

Greetings,

I am having performance issues migrating a particular DTS package to SSIS. A particular step is taking a LOT longer time to complete in SSIS than it does...

"Head banging" and "brick wall" come to mind.

No. Did you read the...

Yes.

I did a quick search and found this[/url]. Looks good enough to point you in the right direction, but there are loads of easy-to-find resources out there courtesy of Google.

Hardcore table names? I'm thinking your mind isn't 100% focused on ETL...

Here's another possibility:

declare @t1 table (Id int)

insert into @t1 (Id)

select 1 union

select 2 union

select 3

declare @t2 table (Id int, X int)

insert into @t2 (Id, X)

select 1, 10 union

select...

justforgroups2004 (11/5/2012)

---

Hi Everybody 🙂

We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are...

What I would recommend is that you get your package working with a simple design and then just add the rest of the features and refinements one by one, testing...