Andy Leonard (6/21/2016)

---

Thanks Phil!

Environment Variables are easier to change and appear (to me)...

brianconner (6/21/2016)

---

Hi All,

I am having a hard time importing a text file that was given to me that is delimited by 3 pipes.

I am manually importing by right clicking on...

How about selecting one pipe as your delimiter and then throwing away the empty columns?

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?