Dataflow task.

UNC paths need to use local disks, as far as I know. But if you can map a drive to another server, you should also be able to point a...

If you log in as that service account, are you able to navigate to that path in Windows Explorer? Is that definitely a local drive on the server?

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] ,...