Thanks again Erland for you help and jumpstart,

I finished writing loop sp and dynamic sql that will go over that xml to produce what I need

SELECT

c1.value('(testsuite/testcase/@internalid)[1]',...

Sorry, Erland

it works as designed, not sure what was wrong on my first run.

Thanks much.

Mario

Now I'll try do some pivoting to look it right one testcase = 1 row, so...

Thanks, Erland for those fixes.

I ran your version OK, but got nothing (NULL + NULL).

my final task to produce something like this, but for first ran name + summary will...

I actually was able to complete this task in SSRS doing group and sort, but just itching to do this in plain SQL.

Best

mario

Thanks, SS

Below is the only column in the whole dstx which has CodePage = 65001, DataType = TextStream[DT_TEXT]:

Flat File Source Error Output

_Output Columns

___Flat file Source Error Output Column

FlatFile.txt is...

Hi, all

After making myself very confy around log and diff backups, I now looking how to make it easier: how to bring that increments but only from single...

Thanks much TheSQLGuru and Mr.Fritchey !!!!

Going to check both options starting with build in, it's good start for me.

Best

Mario

Thanks, DeWayne

This works !!!!

Mario

Thanks SSCarpal,

Wow!!!, adding rows instead of columns, can you expand this topic a bit, if new client need to add extra info for given transaction, like Sex_ID for customer who...

Thanks, and then still deploy ?

dtexec.exe /F works OK without any deployment.

M

Salut, Koen !!!!!!!!!!!!

Thanksk for your helping hand!!.

I did this package on VS 2010, running SQLS 2012, I tried pretty much everything, can run from Agent but only thru...

Thanks, Jack

As an app developer, I really don't have this info, and can't measure any load on server.

I"ll talk to our server guy, for now I'm trying to tune...

I actually found a solution, but just for one part of job

--- this is OK

,CASE WHEN @SortColumn = 'Level' AND @SortDir =...

Tx again, Eirikur.

This is enough information for me to understand that it was not taken into account, it was done by default on the fly. And I can't realy...

Hi, Eirikur

This is one way Xactional Replication, I suspect that was done in bulk, I don't really know answer about article, most likely it default (so could be Table only?),...