elee1969 (4/28/2014)

---

Phil Parkin (4/25/2014)

---

elee1969 (4/24/2014)

---

Hello - I am trying to find out what is the best way to have my ssis package export data to flat file on a mapped...

vanka.sravanthi (4/28/2014)

---

Hi,

I can't able to get the data from remote server.I ma getting only headerrs not getting data.it 'll throwing below error:

System.Net.WebException: The remote server returned an error: (500) Internal...

elee1969 (4/24/2014)

---

Hello - I am trying to find out what is the best way to have my ssis package export data to flat file on a mapped network share. This...

I wish SSIS could possibly tell the user what the "current variable type" is; as I don't have the foggiest notion why the integer in my table can't map to...

Tony1234 (4/23/2014)

---

Hi Lempster,

Thank You very much for your replay.

Exactly I am expecting row count. But the approach you have mentioned will not workout for my scenario because, I am executing...

Are you able to break down the load times for the different components?

I'm guessing that it's the fact table reload that takes most time. Have you tried using (cached) lookups...

So do you truncate your fact table every load too?

Anjan Wahwar (4/15/2014)

---

Hi All,

I have the requirement to load source txt file and perform incremental update on my destination table. As I was not allowed to create any table to...

I mean are you redirecting error rows - have you checked...

Resender (4/14/2014)

---

yes I changed them both from string DT_STR to DT_WSTR & that leads...

Did you modify the datatype of the column in both 'External Columns' and 'Output Columns'?

a4apple (4/10/2014)

---

Unnati, see this.. You will be needing to use a Select statement like this and capture the result.

DECLARE @String VARCHAR(MAX) = 'SourceFile1_20140803073209.txt'

DECLARE @String1 VARCHAR(MAX) ='SourceFile1_2014073209.txt'

SELECT @String AS [String] ,...

The complexity of the problem means that a derived column solution is unlikely to be practical.

A Script Component would allow you to write code with as much complexity as you...

Can you post the error...

Resender (4/11/2014)

---

Ok, I've been confronted by this problem during the week where I'm the only guy not on break on our SQL team.

I got a series of databases that have...