polkadot (1/14/2014)

---

I did answer Montana Life's questions. Not like me not to. Oh Oh Phil, Do you need to have your eyes checked? 😛

For now I've removed the EID...

DaveDB (1/14/2014)

---

Simple enough Phil.... And I didn't need a unicycle 🙂

Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own...

DaveDB (1/13/2014)

---

Hi Phil,

Nice to see you again 🙂

I just need to know what the syntax is to include weekends based on a simple date range. Not sure why you would...

ducon (1/13/2014)

---

Your powers of observation are quite strong despite the look of your profile pic ;).

I was commenting on the old post about the need to troubleshoot and debut packages...

You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get...

Lempster (1/13/2014)

---

Phil Parkin (1/12/2014)

Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not...

ducon (1/13/2014)

---

You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where...

polkadot (1/12/2014)

---

I installed BIDS 2012 but I think it just integrates Visual Studio 2010 within it's shell, and in my case it detects my 2010 packages but when I try...

Thanks for getting into deeper

Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there...

Great, that helps.

Now my question is: why in the above is there a NULL after...

sql crazy kid (1/12/2014)

---

Phil Parkin (1/12/2014)

---

Columns are not missing here . I have 5 column here ,looks like this.

[Just a sample data ,but this is the format we load]

col1...

What...

Here is few more details

Backend - SQL server 2008 R2,SSIS installed

OS - Unix Env

We have many process running on unix ,connecting to sql server , BCP into sql tables ,...

sql crazy kid (1/12/2014)

---

Phil Parkin (1/12/2014)

---

To do what, precisely?

As you have given no examples of the data which is giving you problems,...

To do what, precisely?

As you have given no examples of the data which is giving you problems, providing any sort of useful...