anthony.green (6/21/2012)

---

What edition of SQL server?

2012 runs SQL Data Tools which is built on VS20120

2008+R2 runs BIDS2008 which is built on VS2008

2005 runs BIDS2005 which is built on VS2005

I always...

sorry Lynn, the problem was i was not able to connect the integration services theorugh SSMS....i get the following error Lynn....

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:...

anthony.green (6/21/2012)

---

What edition of SQL server?

2012 runs SQL Data Tools which is built on VS20120

2008+R2 runs BIDS2008 which is built on VS2008

2005 runs BIDS2005 which is built on VS2005

I always...

donpolix-313947 (6/21/2012)

---

MS ole db provider for db2 requires Enterprise edition of sql.

..and I believe for you to obtain IBM IseriesClientAccess software from IBM site, you'll need IBM userid/password if you...

Eugene Elutin (6/13/2012)

---

It will help, but, will it satisfy your performance requirements (if any)? It is really depends on what you load and what transformations and validation you perform. I...

Thanks Eugene..

but when i googled about...

Koen Verbeeck (6/8/2012)

---

Why don't you just assign a sequencenumber to the same incident references, instead of this overly complicated datetime function?

If you would get rid of the function and the...

Koen Verbeeck (6/8/2012)

---

Try to get those functions out of your join columns, if you want to use indexes.

This also seems problematic:

,dbo.GetDateTimeAdd(INCALD, (

row_Number() OVER (

PARTITION BY sc.PnxCodeValue

,a.IAREF# ORDER BY a.IAREF#

) +...

Lynn Pettis (6/7/2012)

---

Here is your code formatted:

SELECT i.IncidentIDRef

,(

row_Number() OVER (

PARTITION BY sc.PnxCodeValue

,a.IAREF# ORDER BY a.IAREF#

) + 2

) seqno

,'Type: ' + IATYPE + ' | Last Name: ' + IALNAM +...

rick.gotner (6/7/2012)

---

Have you checked your disk space on the target server? I've seen sql server grind to a halt during such a transfer when it ran out of disk...

Lynn Pettis (6/7/2012)

---

Charmer (6/7/2012)

---

GSquared (6/7/2012)

---

There isn't one built in, but a date-check regex should be easy enough to build into a script component. Bing/Google/whatever, ".net date regex", and you'll...

select

i.IncidentIDRef

, (row_Number() over (partition by sc.PnxCodeValue ,a.IAREF# order by a.IAREF#) + 2 ) seqno

, 'Type: ' + IATYPE

+ ' | Last Name: '...

Smash125 (6/7/2012)

---

What i can think of

Use OLE DB Source and select either 'SQL Command from variable' and 'SQL Command'

In 'SQL command' you can execute the same ...

GSquared (6/7/2012)

---

There isn't one built in, but a date-check regex should be easy enough to build into a script component. Bing/Google/whatever, ".net date regex", and you'll find several samples...

select

i.IncidentIDRef

, (row_Number() over (partition by sc.PnxCodeValue ,a.IAREF# order by a.IAREF#) +...