What version of SSIS are you using?

I sympathise. Can you confirm that you have got to the point where:

a) Package 1 works.

b) Take a copy of package 1 (as...

sistemas_casinomnes (2/26/2013)

---

Hello, I need help to calculate an expression in sql.

For example I have to send (248/5)*30 to a store procedure or to a function and the sp or the...

YarHad (2/26/2013)

---

Hi All,

Is there way to in SSIS to delete the contents of a text file before importing data into it? Just how you can truncate a table before...

When you copy a package, there are a couple of things you should do which may help minimise meta data issues:

1) Use File/Save As from within BIDS rather than doing...

Which database name?

Obviously, the stored proc has to live in a known location and...

Mackers (2/26/2013)

---

The only ways I can think of doing this are by generating & running dynamic SQL statements either through a stored proc (passing the table names as variables) or...

OK, I'm not getting any closer to understanding what you want.

Can you provide some sample data showing what you currently have and what you want to have?

If you put the Excel file on a local (to the server) drive, do you get the same error?

latingntlman (2/25/2013)

---

I've been tasked in creating an ssis solution which extracts data once a day, loads specific fields and exports them to a .txt file (pipe delimited), As the final...

mbrady5 (2/22/2013)

---

There will not be an exact (date match) in the exchange view. This is updated once per week.

What I was thinking about doing is adding a week and year...

Yeah that makes sense.

I don't think it matters much where you put it - maybe between (4) and (5) would work well.

Regarding the lookup itself - will there be an...

Sounds like a textbook use for the lookup transformation to me - go for it.

Do you have specific questions about how to set things up?

sameerarjuna (2/21/2013)

---

I am new to SSIS , new to the forum too 😀 .

I have been reading books and reading online for the past few days and created a...

Debbie Edwards (2/21/2013)

---

Excellent piece and its helped me figure out my problem with adding the files to a folder.

My problem is that my folders arent on the C drive but...

mister.magoo (2/21/2013)

---

I like this idea, but only if...