You have to convince them you are loosing so much time already that they are now loosing money by sticking to their rules. Also I don't see a reason not...

Alexander G. (5/11/2009)

---

Hi,

I want to process several files within a foreach loop. The loop contains a data flow that reads data that has to be appended to a raw file....

metalray (5/14/2009)

---

Hello,

I am using an SSIS package with the natvie ole db\oracle provider for ole db to copy data across to

my oracle db. I a test-sub set of 700 000...

For easier solution, check third-party CozyRoc SFTP Task. It does support both SSH and FTPS connections and you can get remote file time stamp thru IFileInfo interface.

Do not hesitate to...

Check SSIS documenter[/url]. It will help in your documentation efforts.

bmturney (5/14/2009)

---

How do pass variables to a sql statement in a lookup transform?

I have a package that I'm putting together... and at the beginning of the package I load up...

bmturney (5/14/2009)

---

How do pass variables to a sql statement in a lookup transform?

I have a package that I'm putting together... and at the beginning of the package I load up...

cvrupesh (5/13/2009)

---

Hi All,

I am having a table named item_data where in item and active_date are two columns.

Another table is Error_log where the columns are item,store,tran_date.

I want to update active_date for...

drwhitaker (5/13/2009)

---

I am receiving an error when trying to view my SSIS packages within SQL 2005 BIDS. The error is:

Micrsoft Visual Studio is unable to load this document: ...

stricknyn (5/13/2009)

---

Hello all,

I'm trying to figure out how to send mail via the Send Mail Task. My SMTP server requires a username and password. When I create an SMTP...

Phil Parkin (5/11/2009)

---

Hi guys - I bet you thought that this was all over? :hehe:

I tried out Ramesh's code and have a follow-up question: what is the data type of...

Review your proxy account, allocating additional database permissions for accomplishing the task at...

Phil Parkin (5/11/2009)

---

Ramesh (5/11/2009)

---

I overcome this issue by converting the text column back to string and then doing the replace in SSIS Script component.

Here is that script:

Imports System

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public...

Phil Parkin (5/11/2009)

---

Thanks for the idea - tried it and:

The function REPLACE does not support the data type "DT_TEXT" for parameter number 1. The type of the parameter could not...

donbuz (5/11/2009)

---

Not at all. Would you recommend to "INSERT INTO FROM (SELECT)" approach?

The concept would in the end to have this ETL component (without the T...like you mentionned) part of...