I echo others' comments about DDL ...

But also noticed that your SQL has a spurious comma between

't2.dbo.tblQuestions.Question'

and 'FROM'

quillis131 (1/23/2013)

---

samvanga (1/22/2013)

---

You may want to look at BIML (Business Intelligence Markup Language). It comes with BIDS Helper.

It's metadata driven and allows you to automate SSIS package generation.

I've implemented this...

I imagine so.

At worst, SSIS can create the file locally and then you can use a Script Task with whatever C# code is required to achieve this.

But never tried...

vax09 (1/24/2013)

---

I need to store results of two ssis package into one excel sheet.

columns are defined but the problem is when i run the second package it start from...

Why not get yourself a copy of SQL Server Express 2012 and restore the db to an instance there.

Here's a link. You should get one of the Management Studio versions...

What's your data source?

If it's an RDBMS of some sort, you could always change it to a query containing a UNION:

select [good stuff]

union

select [vapour stuff]

You're on the right track, I think.

But what I would do is create a try ... catch block and attempt to do the convert to date in the 'try' bit....

I'd probably leave the package exporting to a fixed file name and add a final File System Task (or Script Task if you prefer to write a bit of code)...

Oops, bad code deleted!

Have you tried using a data conversion component?

--Statement 2

select * from @Table1

where (column2 != 'AP' or column3 != 'U')

After your Excel source, add a data conversion component.

Use it to convert your problematical column to DT_STR. You will see at this point that you are able to specify the...

I would guess that you have created a column in your dataflow called 'Copy of SSN' and that the error is occurring because you have mapped this column to one...

Nice error message. What's your question exactly?

I would like to hear your reasons behind this comment. In many circumstances, a staging table SSIS solution will be one or...