Capt. Sigerson (12/23/2011)

---

If anybody's still listening, I've run into a small wall in SSIS. I get a quote-delimited CSV file that I want to upload to a SQL Server...

You will have to give more information. Can you post a screenshot, as well as the expression you are using?

jeberhard-623651 (12/23/2011)

---

You would think Microsoft would make getting data from a SQL database to an Excel file easier than this. I still haven't gotten it to work but I'm...

jnawrocki (12/22/2011)

---

I have a parameter in a report (SSAS data source) that is defined as a date range inclusive. In the query designer it only list one parameter. When you...

jeberhard-623651 (12/23/2011)

---

Thanks. I think I tried deleting the excel file first and then got mapping errors in the data flow task. I had manually deleted the file from...

I guess it's...

srik.kotte (12/22/2011)

---

I have selected ignore failure for truncation and ran the package. But the data is getting truncated. How to solve this error. In my dest table for this column...

The data was truncated because it could either not fit into the destination column, or your metadata is not correct.

Check the input/output columns in the data flow, and also make...

SQL Agent is a scheduling tool only...not a development platform. You cannot create components for user interaction (like inputboxes)...

srik.kotte (12/16/2011)

---

Hello All,

I have a requirement like this.When someone executes my ssis package, I want the user to be prompted to fill in a few parameters. How do i do...

Please do not double post...

Replied here: http://www.sqlservercentral.com/Forums/Topic1221537-364-1.aspx

There's no built-in functionality for this as far as I know, but it would be possible to do it with a script task.

Doing it that way will be very cumbersome...

Books Online is your friend in...

rasikawtc (12/8/2011)

---

Hi

Is there a way to split a huge excel file into smaller files while exporting

for example if there are 10,0000 rows in the report when exported into excel...

I think the issue could be how SSIS passes that parameter...

Use the expression builder in the Execute SQL Task properties to set the "SqlStatementSource" propery of the task.

The expression should...