Did you check out the Split method?

http://msdn.microsoft.com/en-us/library/system.string.split(v=vs.110).aspx

How does your query look like?

You can store your results in a variable by using it in the SELECT statement:

SELECT @myVariable = columnA FROM myTable;

You can store results of the...

kapil_kk (10/25/2012)

---

One question, I am confused on this...

select ID, name name from person

select ID ID, name name from person

Both these statements dont give any error message and run successfully...

wht is...

An easy one to close the week, thanks!

They can open up the Visio diagram and admire the pretty colors.

No. PerformancePoint integrates only with SharePoint.

You just write the same column (number 5 in your flat file) twice to the database.

Once as a PK, once as a FK. So you need two OLE DB Destinations...

Use * as the delimiter for your flat file in the flat file connection manager.

Duplicate the stream using the Multicast.

Put two OLE DB destinations to your table, but write only...

That is really limited.

You can connect shapes to a datasource and change the color of the shape (for example) according to the data.

Example:

you have a visio diagram of your server...

What exactly do you mean with Visio Reporting Services?

Do you mean Visio Services in SharePoint?

Ah yes, I understand. You cannot deploy SSIS 2012 projects to SQL Server 2008R2 or older. You can only deploy to SQL Server 2012.

In Visual Studio 2010 (SQL Server Data...

You can start by reading this article series by Devin Knight:

http://devinknightsql.wordpress.com/2012/03/01/choosing-the-right-microsoft-reporting-technology-part-1-report-services/

It compares all the reporting tools and lists their strength and weaknesses.

It also includes PerformancePoint, which I forgot in my...

That's not what I asked 🙂 I asked which model you were using.

In SSIS 2012 you have two models:

* project deployment model: a new model, which has parameters and project...

Daniel Bowlin (10/24/2012)

---

Excel and PowerPivot directly connected to the database. There is also a tool in 2012 (I forget the name) that is very much like Tableau and supposedly...

Are you using the project deployment model or the package deployment model?