On this, I think we shall have to agree to...

Presumably you mean a global temp table.

Although it would probably work, it's a bad idea - it...

John's suggestion is the way I would do it.

I would also have a process to move unwanted / processed / duplicate batch files somewhere else, to keep the 'to be...

Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.

Script Tasks are used in the Control Flow (and...

Having a CTE which is effectively defined as

select * from (subquery)

is somewhat bizarre too.

You've been here long enough to know how to post questions - not only does your...

Bill McDonough (2/2/2007)

---

One way to do this is a script task. In the script, you'll have something like this:

PublicOverrides Sub ProcessInputRow(ByVal Row as rowInBuffer)

In that function, you can usethis...

vasu1.vi (7/26/2013)

---

Hi

I am working on a package that needs to populate currentdate when we insert new row on the table. For this i am using getdate() in the vaiable. when...

wolfkillj (7/25/2013)

---

A data source has to be able to access the metadata to expose its output columns. I haven't verified this, but I don't think the metadata of a data...

peterzeke (7/26/2013)

---

Thanks for such a quick reply, Phil.

As you suggested, I exported a spreadsheet as a text file. The values in the text file match the values in the...

Could it be that formatting has been applied in Excel to display the value to 2 decimal places?

Try exporting from Excel to CSV and then using Notepad to see what's...

aaron.reese (7/23/2013)

---

Phil, Thanks but no thanks 🙂

I hate regex. The regex would need to treat it as a string (either explicitly or cast in a derived column) and then...

If you're a fan of Regular Expressions, you could do a Regex match on it to reject anything other than

NNNN-NN-NN

where N is in the range [0-9].

Are you saying that...

That's more like it, thanks for taking the time to clarify Jason.

I understand that you were trying not to get too technical with your first answer & just wanted to...

Create a query which runs against your Oracle data.

The query should return the data in the format you want to insert to SQL Server.

Use the query within a data flow...