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...

No, there isn't one - at least last time I checked. But there is a generic SSIS forum here which seems to...

Lowell (1/10/2014)

---

I've got just enough exposure to SSIS to think the following is true: an SSIS project defines all it'sc olumns and datatypes before it does anything like insert them...

That is the reason.

Inserts are best done using a dataflow.

Updates are best done as a set-based operation - meaning that the OLEDB command is NOT the way to go. One possibility is funneling...

"Vice"? What is that?

harsimranjeetsinghwasson (1/9/2014)

---

I have a store procedure that is source for creation of my CSV, it take one minute to execute to 100000 records

and this result set is used to preparing...