This does not answer the question at all.

karthick.alangattan (2/27/2013)

---

How to convert datetime to string format (YYYYMMDD) in SSIS?

I have done using Datepart but for the date 01 to 09 it gives the values as 1 to 9....

There's more than one way that this might be done, but one which...

Sounds perfectly do-able to me, though I have some questions:

1) Does the proc always output recordsets with the same meta data?

2) What do you want your output to look like?...

sameerarjuna (2/26/2013)

---

I have a scenario , where I need to fetch data from Database 1 (on Server 1) and insert into Database 2( on Server 2) on a particular condition.

I...

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