SQL!$@w$0ME (6/21/2016)

---

Hi Folks,

I have a requirement for a table refresh (truncate/load) that needs to happen daily from Oracle to SQL. The table is relatively small. What is the best approach...

1) Create a connection from SSIS server to the Citrix server.

2) Set up data flow component (or whatever means you want to use to transfer the data)

3) Run package.

Johan_1975 (6/21/2016)

---

Hello,

We're Tuesday. It's important for what's coming.

I encountered an issue on the DATENAME function and need some help.

If I type :

SELECT DATEPART(dw,GETDATE())

It returns 2 (for Tuesday)

If I type...

Well done for tackling this topic, Andy.

I use SSISDB environments a lot, but have never used parameter overrides. Do you have a view on when they should be used in...

If you choose a pipe-delimited flat file, you won't go too far wrong (assuming there is no possibility of a pipe (|) appearing in the data you are loading.

Luis Cazares (6/17/2016)

---

It's using the formula shown on BOL.

Considering example 1.00 / 7.1 we just get the formulas.

p = p1 - s1 + s2 + max(6, s1 + p2 +...

Nice example, Luis.

One thing which is unclear to me in all this is how SQL Server determines precision and scale for a given calculation. For example

1.00 / 7.1

which, according to...

cstg85 (6/17/2016)

---

Phil,

Thank you very much for the advice, I used SQL queries in my SSIS package instead of a merge join and created a static table to be truncated each...

sunil.mvs (6/17/2016)

---

Hi,

Thanks for looking into my question. I am rephrasing my question to make you to understand

How to use TFS , to...

neophilius (6/17/2016)

---

Hi!

I have to consume a Rest API where we have our survey data. Here I want to save the data in my database and update the data every night....

Yes, that an easy and robust way.

Or will an SSIS...

This is somewhat terse – what is your question, exactly?

What problem are you having?

komal145 (6/15/2016)

---

Since Stage table is raw data and destination is key columns we cannot merge Stage and destination.

my package is something like below

Stage(Column1 , column2)

|

|

Lookup1(get Column1key1)

|

|

Lookup2(get Column2key2)

|

|

Destination (...

The standard way of doing this is to load your data into a staging area and then to do a MERGE (which is potentially less expensive than DELETE/INSERT) into the...