Simple solution, use the ForEach File to move the files to an "unzip" directory and unzip from there to the Fileprocess directory.

😎

This article might help

Configuring the Integration Services Service (SSIS Service)

😎

mister.magoo (5/17/2014)

---

I forgot to mention that you cannot have an xml version declaration in an XML datatype in SQL Server, so once you have the xml how you want it,...

For this I use either vi/vim...

A hunch, if the catalogs are set to "do not track changes", I believe the upgrade will not rebuild them.

Whether you HAVE to, I don't know, last time I upgraded...

A quick thought, build an alter catalog sql string and run in each db?

😎

SELECT

CONCAT('ALTER FULLTEXT CATALOG ',FTC.name,' REBUILD;')

FROM sys.fulltext_catalogs FTC

You might want to correct the problem at schema...

What about SSIS?

😎

Take a look at the XML forum, the answer is there.

BTW, it is more work to create a sample data than actually write the answer.

😎

Promptly confirmed!

.....then.....:sick:

First thing to run

SELECT

*

into dbo.myAudittable

FROM sys.dm_exec_connections c

cross apply sys.dm_exec_sql_text(c.most_recent_sql_handle)

If you are lucky, you'll have the culprit there.

😎

Prefixing the output column alias with the @ (ascii 64) sign does the trick

😎

amela.ajanovic90 (5/16/2014)

---

Thanks to everyone who filled out the questionnaire! I have posted on non technical sites as well, we have around 70 responses so far, but of course, the more...

mianirfan786 81909 (5/16/2014)

---

Dear All,

I have a VB based desktop application with back end MS SQL server 2000 database with server machine ibmx5650 with specs intel xeon 2.7GHz (24 CPU's) &...

Is there any error handling in SP_LogProc?

😎