paul.j.kemna (1/11/2013)

---

I don't see a forum for SSIS 2008, so I guess I will post here??

I have an OLE DB connection to an IBM DB2 source. I am trying to...

I'd suggest exporting the Excel data to CSV format and importing that instead. You'll save yourself a grey hair or two. Mixed-datatype columns in Excel have cost the world numerous...

mister.magoo (1/10/2013)

---

opc.three (1/10/2013)

---

Nice offering MM. The technique is one I have seen outlined before but not necessarily applied to SSIS. While no one step is difficult there are quite a...

If the column names and datatypes change every day,...

It won't work with Excel files without tweaking the...

bobd125 (1/10/2013)

---

I have a Execute T-SQL task which purged records from table. I would like to record in a log file the record count of how many records where...

Lidou123 (1/10/2013)

---

Phil Parkin (1/10/2013)

---

Lidou123 (1/10/2013)

---

Hi All,

Very difficult - SSIS is meta data driven and changing meta data gives it a severe headache.

Also, if your columns change every day, how will...

Lidou123 (1/10/2013)

---

Hi All,

Please I need your help.

I have an excel file File.xls that i want to load in a table TempTable. But my File.xls can have columns that change everyday.

I...

Files?

You mentioned only one in your first post.

Are you saying that it previously wrote...

mpradeep23 (1/10/2013)

---

i have two tables in two sql servers i need two move data from one table to other on insert /update i had written a ssis package for this...

Apologies if you've already mentioned this - I did not see it when I skimmed the thread - but have you tried running the packages manually in BIDS? (Eek, first...

mister.magoo (1/9/2013)

---

If you are using xlsx files, there is a way that is not too difficult if you are methodical...