Port1433 (4/11/2014)

---

Does anyone know where is the best place for taking courses in IT to break into the field for those who arts students. I would like to take SQL...

use below..

SELECT a.c.value('(.)', 'varchar(100)') [EmpID]

FROM @data.nodes ('employeelist/employeeid') a ( c )

It's upto you to use Varchar or INT.. I just use Varchar for alphanumeric data...

You have to use an expression builder to create the file name and assign it to the CSV connection manager. Then you can assign the particular file name with date...

cook155 (4/11/2014)

---

Yes, it was in fact the first solution i tried because the same thing was recommended to my by someone else. I tried all impersonation methods and was wondering...

Use the lookup transformation after the source which can serve your purpose(Instead of Writing query).

10000 is a very small number, it should be a cake walk for ssis until there...

If you are dealing with a lot of DML operations, remove the indexes as the first step, and re create at the end after the data load happens. Are you...

Did you get a chance to try the route I gave you?

Easiest and reliable way is to Generate scripts and save to a single sql file. one other way for ssis is use a Execute SQL task and write a query...

There are many institutions / providers that does online training / inclass as well. I do for different companies too. If you are not planning to spend much, start with...

Can you also add the desired output to make it easier to understand what you actually mean to convey with this..

See if ranking functions can help you with sequencing numbers....

Sabio (4/11/2014)

---

I have been given an excel spreadsheet that contains a column with about 10000 ids. I need to use the data from that single column (ids) in a SQL...

If a delay is okay, Incremental data loads at maintenance...

Bottom

scottcabral (4/10/2014)

---

SSC Journeyman,

I guess it could be. I was thinking of creating each report as a separate rdl file and then combining them into 1 report based on the...

@OP,

1) If you want to show just the totals for both of them, Use a Rollup. Without roll up, what happens is you cannot use the Group by anymore since...